DBMS_Metadata package wrapping lines
411002Jan 10 2005 — edited Jul 11 2006How can you set the line size for the DDL that is generated from the DBMS_MetaData pkg? If I try to run the script that is generated by this output, I get errors because things are wrapped.
I used this sql to generate my ddl:
select dbms_metadata.get_ddl('TABLE','EMP') FROM DUAL;
Anybody have a good idea on how to get this output to work properly?
Thanks,
Jim