JSON_VALUE function in Store Procedure

[Former Member]

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.

[christoph_gilde]

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

[Former Member]

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