Re: SERVEROUTPUT Status

ben p wrote:

> Hello there,
> does anybody know a way I can check the value of serveroutput from
> within a block ? In sqlplus you can do 'show serveroutput' but i cant
> find a way of getting this info in some plsql. Im trying to write a
> function to work out if serveroutput is on / off.
> Cheers
> Ben

You shouldn't want to see it within a block. DBMS_OUTPUT does not belong in production code: Ever!

If you want to know the value of a variable ... insert it into a table.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)