Sep 08, 2017 at 07:42 AM

How to build procedure with $ variable

42 Views

Hi,

I'm trying to prepare a procedure containing the "$" expression. Unfortunately, when I try to call it I have the error as below. Is HANA allow to create such queries? There is no problem with formatted search. Below is an example query and an error that returns.

CREATE PROCEDURE TEST_PROC

LANGUAGE SQLSCRIPT AS

cardCode nvarchar(15);

BEGIN SELECT $[$4.1.0] INTO cardCode FROM DUMMY;

END;

"Could not execute 'CREATE PROCEDURE TEST_PROC LANGUAGE SQLSCRIPT AS cardCode nvarchar(15); BEGIN SELECT $[$4.1.0] INTO ...' SAP DBTech JDBC: [257]: sql syntax error: incorrect syntax near "$": line 8 col 8 (at pos 96)"

I also tried using $[OINV."CardCode"]. The effect is the same.

I also tried passing this parameter from document to procedure as an input parameter. As a result, SAP freezes. The mechanism I create is supposed to work in a background in the authorization process.

Regards,

Sebastian