I was wondering why in the errpkg from stevens book (oracle plsql programming)
/* Re-raise any other exception using dynamic PL/SQL. */
EXECUTE IMMEDIATE 'DECLARE myexc EXCEPTION; '
|| ' PRAGMA EXCEPTION_INIT (myexc, '
|| TO_CHAR (err_in)
|| 'BEGIN RAISE myexc; END;';
we use dynamic sql here and not static sql
Help get this topic noticed by sharing it on Twitter, Facebook, or email.