Skip to Content
0
Former Member
Apr 12, 2016 at 10:51 PM

Current_Date Variable pass to HANA Calculation view via Stored Procedure

1726 Views

Hi All,

I am having trouble creating a variable in a stored procedure which will pass the current date into the Input Parameter of a calculation view.

Any help would be great.!

Thanks in advance.

------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

PROCEDURE "MY_TEST"."TEST::TEST_QUERY" ( )

LANGUAGE SQLSCRIPT

SQL SECURITY INVOKER

DEFAULT SCHEMA "MY_TEST"

AS

BEGIN

/*****************************

Write your procedure logic

*****************************/

DECLARE var_commit VARCHAR(100) := 'COMMIT';

DECLARE var_rollback VARCHAR(100) := 'ROLLBACK' ;

DECLARE var_cdate date:= to_date(current_date);

DECLARE EXIT HANDLER FOR SQLEXCEPTION

BEGIN

exec (:var_rollback);

--ex_message := 'Error Code '||::SQL_ERROR_CODE||::SQL_ERROR_MESSAGE;

END;

SELECT * FROM "_SYS_BIC"."TEST/TEST_QUERY"

('PLACEHOLDER' = ('$$P_ENDDATE$$', var_cdate),

'PLACEHOLDER' = ('$$P_STARTDATE$$',var_cdate))

exec (:var_commit);

END;