Skip to Content
1

SBO HANA Query and Procedures

Apr 04, 2017 at 03:44 PM

56

avatar image

Hello All,

I am playing with SBO on HANA and trying to get some user queries to work. Like I did on MSSQL I try to keep the query within SBO pretty small and do the "magic" in a stored procedure. And here my pain begins. I am not able to call a stored procedure with variables as input parameters. Here in details the Code from my stored procedure:

CREATE PROCEDURE SBODEMODE.SP_Test				
(
	in vonDatum timestamp,
	in bisDatum timestamp	
)
LANGUAGE SQLSCRIPT
AS
begin

select :vonDatum AS "From Date", :bisDatum AS "To Date" FROM dummy;

end;

And here how I try to call it from SBO:

/* select from [dbo].[OINV] T0 */
Declare vonDatum timestamp;
vonDatum := /* T0."DocDate" */ '[%0]';

/* select from [dbo].[OINV] T0 */
Declare bisDatum timestamp;
bisDatum := /* T0."DocDate" */ '[%1]';

CALL SP_Test (:vonDatum,:bisDatum)

The only way I get the call within SBO to work is with a hardcoded date. Has anyone some ideas how to solve such things better?

Thank you for your time,

Michael

(used Version SBO4H 9.2 PL07)

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers