Faced a syntax error when running a procedure with variables

[#1]

Hello Colleagues,

I faced here a issue, after a long time of Brushing up my coding skills and looks ugly .

PROCEDURE "HeatSensorWserv"(
SensorID NVARCHAR(250),
Event_Timestamp Timestamp,
RecordedHeat Decimal(6,2),
Current_ERecording DECIMAL(6,2),
Status NVARCHAR(250) )
   LANGUAGE SQLSCRIPT
   SQL SECURITY INVOKER
   AS
BEGIN
DECLARE Maximum_Heat_Previously_recorded DECIMAL(6,2);
DECLARE Minimum_Heat_previously_recorded DECIMAL(6,2);
   /*************************************
       Write your procedure logic 
   *************************************/
   select max(RecordedHeat) from "IND_IOT_PRJ.DBMODULE::CLIMRK.HeatSensorModuleMonitor" into  :Maximum_Heat_Previously_recorded;
   select min(RecordedHeat) from "IND_IOT_PRJ.DBMODULE::CLIMRK.HeatSensorModuleMonitor" into :Minimum_Heat_previously_recorded;
   insert into "IND_IOT_PRJ.DBMODULE::CLIMRK.HeatSensorModuleMonitor" values
   (:SensorID,:Event_Timestamp,:Minimum_Heat_previously_recorded,:Maximum_Heat_Previously_recorded,:RecordedHeat,:Current_ERecording,:Status);
END
RecordedHeat is a table column

Please help me here,where i am getting it wrong!!

Syntax error: "incorrect syntax near ":Maximum_Heat_Previously_recorded"" [8250009]

at "src/procedure/HeatSensorWserv.hdbprocedure" (1

Last question ? is it possible to pass blob files inside procedure ? i am using a post to post information into procedures that write in to HANA Tables.

Br,
Gabriel.

[SreekanthSurampally]

Can you try INTO clause, before FROM clause as shown below.

select max(RecordedHeat) into :Maximum_Heat_Previously_recorded from "IND_IOT_PRJ.DBMODULE::CLIMRK.HeatSensorModuleMonitor";