Version 0.15 of oraddlscript includes two fixes requested by a user of this utility:
To correctly separate the CREATE PACKAGE and CREATE PACKAGE BODY statements of a package, it is necessary to execute the command
DBMS_METADATA.SET_TRANSFORM_PARAM( DBMS_METADATA.SESSION_TRANSFORM, 'SQLTERMINATOR', true);
before calling GET_DDL().
(I am really considering passing SESSION_TRANSFORM parameters from the command line if it should be necessary)
If DDL generation fails, oraddlscript will now additionally output the Oracle error message. This will allow for further debugging if you have database objects that won’t script.
The latest version of oraddlscript is available for download.