For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
create or replace PROCEDURE PROC_PURGE_BATCH_TABLES_TST
AS
V_TBL_NM VARCHAR2(30):='EMPLOYEES';
v_cnt number;
v_dt date := sysdate;
QUERY_1 VARCHAR2(1000);
begin
EXECUTE IMMEDIATE 'SELECT COUNT(1) FROM :1' INTO V_CNT USING V_TBL_NM;
end;