Re: SERVEROUTPUT Status

Hi Ben,

serveroutput is a SQL*Plus construct. It simply does a dbms_output.enable when the call is made and also automatically in the background does the dbms_output.get_line calls after any insert, update, delete or anonymous block. These are the only ways to run triggers or cause pl/sql to be executed.

I cannot see how you can check if the package is enabled in pl/sql as the call to enable sets a boolean in the enable function that is private to the package body and the package body is wrapped so it cannot be changed to add a function to check this variable or to simply expose it. How do i know this? - easy, in earlier versions of Oracle the package body was also shipped as PL/SQL and could be read.

You could set a flag, either in a table or a variable declared in SQL*Plus and use that instead.

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.