topic Re: JSON_VALUE function in Store Procedure in Application Development and Automation Discussions

JSON_VALUE function in Store Procedure

Former Member — Fri, 04 Aug 2017 17:49:01 GMT

I want to create the store procedure but failed to create. my code:

CREATE PROCEDURE "TESTING"."SCALAR_VARIABLE_EXAMPLE_INSERT" (IN paramin NVARCHAR(5000))
                LANGUAGE SQLSCRIPT
                SQL SECURITY INVOKER
                AS
BEGIN
                DECLARE username varchar(20) := 'bobbyss';
                DECLARE description varchar(100);
                description := 'select JSON_VALUE('''||:paramin||''', ''$.description'') AS "desc" from DUMMY';
                INSERT INTO "TESTING"."USER" VALUES (:username, :description);
END;

When I call this procedure, show SQL syntax error: incorrect syntax near "select". How to fix this problem? Thanks.

Re: JSON_VALUE function in Store Procedure

christoph_gilde — Sat, 05 Aug 2017 20:47:57 GMT

See https://stackoverflow.com/questions/45497306/store-procedure-in-sap-hana-2-0-insert-from-parameter/45512267#45512267

Re: JSON_VALUE function in Store Procedure

Former Member — Mon, 07 Aug 2017 15:54:52 GMT

Hi Glide,

in the post from stackoverflow's you shared, that is my post. the last answer cannot fix my problem. any solution? thanks.

Regards,

Bobby