Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- REPLACE PROCEDURE PD_CCP_FN_DB.master_proc_TEST()
- SQL SECURITY INVOKER
- BEGIN
- DECLARE STMT VARCHAR(4000);
- FOR rec AS Cur CURSOR FOR
- select SP_NAME from WRK_QA_CCP_ATOMIC_DB.SP_CALL
- DO
- SET STMT= ' CALL ' || rec.SP_NAME || '(''PII_SUPP_SMRY_TXN'') ';
- EXECUTE IMMEDIATE STMT;
- END FOR;
- END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement