My database procedure is defined as below -
CREATE PROCEDURE EXAMPLE_SCALAR_VARIABLES7 ( IN IV_CUSTOMID NVARCHAR(8) , IN IV_ADDITIONAL_DISCOUNT INTEGER )
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER
READS SQL DATA AS
LV_DISCOUNT NVARCHAR;
LV_NEW_DISCOUNT NVARCHAR;
BEGIN
SELECT DISCOUNT
INTO LV_DISCOUNT FROM SFLIGHT.SCUSTOM WHERE ID = :IV_CUSTOMID;
LV_NEW_DISCOUNT := :LV_DISCOUNT +
:IV_ADDITIONAL_DISCOUNT;
END;
After creating this procedure via SQL console,
I call the procedure as below-
CALL "HANAUSER"."EXAMPLE_SCALAR_VARIABLES7" ( 00000001, 10 );
But i am getting an error while executing this -
SAP DBTech JDBC: [359]: string is too long: [359] "HANAUSER"."EXAMPLE_SCALAR_VARIABLES7": line 9 col 1 (at pos 240): [359] (range 3) string is too long exception
Please tell me what is the issue conceptually thanks