Skip to Content
0
Feb 15, 2014 at 04:31 PM

Procedure to get no of records from any table

507 Views

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 ;