Try the following
PROCEDURE execImmed (sql_string IN VARCHAR2)
IS
BEGIN
EXECUTE IMMEDIATE sql_string;
EXCEPTION
WHEN OTHERS
THEN
RAISE;
END;
PROCEDURE dynPLSQL (blk IN VARCHAR2)
IS
BEGIN
execImmed (
'BEGIN ' || RTRIM (blk, ';')...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.