Hi SQL experts,
Could you please help me to write below procedure :
--CREATE TYPE TABLE_TYPE AS TABLE ( "TABLE_NAME" NVARCHAR(30) )
CREATE PROCEDURE GET_ROW_COUNT_ANY (OUT EX_COUNT INTEGER, IN TABLE_NAME TABLE_TYPE )
LANGUAGE SQLSCRIPT
SQL SECURITY INVOKER
READS SQL DATA AS
BEGIN
SELECT COUNT (*) INTO EX_COUNT FROM :TABLE_NAME;
END ;