Skip to Content
0

How to build procedure with $ variable

Sep 08, 2017 at 07:42 AM

9

avatar image
Former Member

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

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

0 Answers