HDBProcedure

[#1]

I have issue when activating .hdbprocedure with error message Dependent object not found: SqlScript; Y: symbol not found

This is the table types

"Common"."ZENC::zar_tt_capability"

And here is the procedure that I am trying to activate. I have also trying with :Y with no luck. Any idea what's wrong?

PROCEDURE "Common"."ZENC::zarx_pcapability" (
	IN X varchar(255), 
	IN Y "Common"."ZENC::zar_tt_capability"
) 
LANGUAGE SQLSCRIPT 
SQL SECURITY INVOKER
--DEFAULT SCHEMA <default_schema_name>
--READS SQL DATA 
AS	
BEGIN
	Delete from "Common"."ZENC::zenc.capabilities" 
	where APPLICATION_ID = X;
	
	Insert into "Common"."ZENC::zenc.capabilities"
	(id, name, owner) 
	select * from Y;	<--- also trying with :Y without success !!
END;