Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> dbms_metadata.set_transform_param 'PRETTY' option does not work

dbms_metadata.set_transform_param 'PRETTY' option does not work

From: Binh Pham <binhpham15_at_hotmail.com>
Date: Thu, 10 May 2007 17:59:41 +0000
Message-ID: <BAY103-F349D64A721C7C81F4EEC10D23A0@phx.gbl>


I issue these statements:

SQL> execute DBMS_METADATA.SET_TRANSFORM_PARAM(DBMS_METADATA.SESSION_TRANSFORM,'PRETTY',true);

SQL> select dbms_metadata.get_ddl('VIEW','AP_TAX_LINES_SUMMARY_V','APPS') from dual

The output does not look PRETTY at all.

Does it only work with certain object types?  This is the description of the option:

PRETTY (all objects) - If TRUE, format the output with indentation and line feeds.
Defaults to TRUE.

Thanks.



Catch suspicious messages before you open themówith Windows Live Hotmail. -- http://www.freelists.org/webpage/oracle-l Received on Thu May 10 2007 - 12:59:41 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US