Skip to Content
0
Jun 05, 2020 at 03:02 AM

SCALAR TYPE IS NOT ALLOWED

2793 Views

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;