Colin, When I try to test this the following error from 'plsql_errstr' indicates that it is not possible to have multiple statements in a SQL string. The PL/SQL statements are not being treated individually. No. Your package spec is trying to contain a package body.
Errors for PACKAGE PLSQL_EXAMPLE: 6.6: PLS-00103: Encountered the symbol "CREATE" Because your package specification needs to be seperate from the package body. Review the syntax for package creation. If you have Procedure Builder on your system, run the script then go to procedure builder and look at the result. Good luck.
