Re: Redirecting output from DBMS_OUTPUT

Originally posted by Gerald Mulholland

> Does anyone know where Oracle stores/logs DBMS_OUTPUT statements
> while the

> user is not logged in to SQL.

>

> I am using the statement

> "DBMS_OUTPUT.PUT_LINE("Error Message text here") within my stored

> procedures and triggers body exception handlers. I would like
> to review

> any error messages if they occur, but do not have a clue where Oracle

> saves such useful information.

>

> My Oracle database is installed on a HP-UX 9000 server.

>

> Thanks

Don't use dbms_output in this scenario... Just create a table and redirect error text into it. It's available to you until you delete it.

Regards

/Rauf Sarwar

--
Posted via http://dbforums.com