Dear all,
I'm trying to excute the store procedure but when I try to excute, I have an error "SAP DBTech JDBC: [1310]: scalar type is not allowed: NHANG: line 18 col 2 (at pos 347)".
What is the issue? I'm a newbie in SAP HANA. Please help me.
Thanks for your help !!
CREATE PROCEDURE AutoItemCode( in nhang nvarchar(50), in lhang nvarchar(50) ) LANGUAGE SQLSCRIPT AS ba nvarchar(20)= '000'; hai nvarchar(20)= '00'; mot nvarchar(20)= '0'; BEGIN DECLARE itemcode nvarchar(50); DECLARE ba nvarchar(20); DECLARE hai nvarchar(20); DECLARE mot nvarchar(20); ba = '000'; hai = '00'; mot = '0'; nhang = select "Code" from "SHF_DB_TEST"."@UDT_NGANHHANG" T0 where "Code" = nhang; lhang = select RIGHT(T0."Code",2) from "SHF_DB_TEST"."@UDT_LOAIHANG" T0 where LEFT(T0."Code",2) = :nhang and T0."Name" = :lhang; END;