Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Oracle plsql programming query (errpgk source code)

hi

I was wondering why in the errpkg from stevens book (oracle plsql programming)
/* Re-raise any other exception using dynamic PL/SQL. */
ELSE
EXECUTE IMMEDIATE 'DECLARE myexc EXCEPTION; '
|| ' PRAGMA EXCEPTION_INIT (myexc, '
|| TO_CHAR (err_in)
|| ');'
|| 'BEGIN RAISE myexc; END;';
END IF;
END;

we use dynamic sql here and not static sql

Regards
Newton
1 person has
this problem
+1
Reply