spool out from PL/SQL Dev

[ccrist]

Anyone know a way to get around the 1,000,000 byte restriction (we're in 9i) of the dbms_output feature?

Would like a way to spool out to a file if possible.

TIA!

-c.

 

[CTzen]

Have you looked at UTL_FILE package?
http://oraclesvca2.oracle.com/docs/cd/B10501_01/appdev.920/a96612/u_file.htm#998101

Also, you can write results into a table, and then select them and spool to file.

 

[Worker]

How about using a Test window and using:

htp.print('

');
[your code, using htp.print() instead of dbms_output.put_line()]
htp.print('

');

Then just look on the "HTP output" tab. Right-click, "View source" will let you save to file. Or if you really want to spool, add some code that reads the htp buffer using OWA.get_line()/OWA.get_page() and uses UTL_FILE to write to a file.