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
BEGIN SELECT $[$4.1.0] INTO cardCode FROM DUMMY;
"Could not execute 'CREATE PROCEDURE TEST_PROC LANGUAGE SQLSCRIPT AS cardCode nvarchar(15); BEGIN SELECT $[$4.1.0] INTO ...' SAP DBTech JDBC: : 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.