Re: output from PL/SQL

From: Gerrit-Jan Linker <gjlinker_at_litconsulting.freeserve.co.uk>
Date: 1999/03/23
Message-ID: <7d8u3c$87p$3@news5.svr.pol.co.uk>#1/1

Hi,

I wrote a utility with which you get instantaneously the messages as they are generated in Oracle. It's called OraDebug. It "prints" the messages into a Windows Application, adds a timestamp etc. You can leave the statements in your PL/SQL when you put it live.

To see the messages again in a live running situation can be achieved by starting the OraDebug windows app and specifying the sessionid of the Oracle session you want to sniff.

I wrote it for my own benefit and can't do without anymore. It's not a full featured debugger but it's much better than dbms_output... well that was not too difficult!...........

Please have a look and try OraDebug at

http://members.aol.com/gjlinker

>I am writing a trigger and for debuging I'd like to have an output.
>I tried to just write into another table and Select it, but as soon as
>the trigger doesen't work properly, the whole thing is roled back, so
>that I can't see a thing.
>Do you know how to make an output?
>As far as I understad using the dbms_output package has the same
>problem.

Regards, Gerrit-Jan Linker Received on Tue Mar 23 1999 - 00:00:00 CST