Update of oraddlscript 0.15

Posted on by

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.

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.