General discussion

Locked

Spool Command in PL/SQL

By bishoy.janardhanan ·
How can we use the spool command in a Oracle PL/SQL script ? i need to output results of a query without using a user created table. the use of dbms_output.put_line gives a overflow error when more than the length is more than 256 bytes.

This conversation is currently closed to new comments.

13 total posts (Page 2 of 2)   Prev   01 | 02
Thread display: Collapse - | Expand +

All Comments

Collapse -

Spool Command in PL/SQL

by vs In reply to Spool Command in PL/SQL

You may set a buffer size for dbms_output by command: dbms_output.enable(buffer_size=512000);
Buffer size cannot be greater than 1000000.

Collapse -

Spool Command in PL/SQL

by bishoy.janardhanan In reply to Spool Command in PL/SQL

The question was auto-closed by TechRepublic

Collapse -

Spool Command in PL/SQL

by bishoy.janardhanan In reply to Spool Command in PL/SQL

This question was auto closed due to inactivity

Back to Web Development Forum
13 total posts (Page 2 of 2)   Prev   01 | 02

Related Discussions

Related Forums