Skip to Content
0
Jul 27, 2016 at 04:23 AM

Error while running the database procedure in HANA - string is too long exception

2282 Views

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