SET SERVEROUTPUT

[jasonhuibers]

I am running a script in SQL PLUS - and a window prompts me with:

Usage: SET SERVEROUTPUT { ON | OFF } [SIZE n]
[ FOR[MAT] { WRA[PPED] | WOR[D_WRAPPED] | TRU[NCATED] } ]

Should I be entering in ON???

Not sure how to bypass this?

 

[SantaMufasa]

The SQL*Plus command that I recommend to allow DBMS_OUTPUT.PUT_LINE to write to your screen is:

set serveroutput on size 1000000 format wrap

The command needs to occur prior to a PL/SQL block that uses the DBMS_OUTPUT.PUT_LINE command.

Mufasa
(aka Dave of Sandy, Utah, USA)
“People may forget what you say, but they will never forget how you made them feel.

 

[jasonhuibers]

That worked great - thank you