Re: Oradebug

From: Karsten Farrell <kfarrell_at_medimpact.com>
Date: Tue, 15 Oct 2002 22:39:57 GMT
Message-ID: <1P0r9.891$Kp6.82952437@newssvr14.news.prodigy.com>

Harry Sheng wrote:
> How can I get oradebug output printed on the screen besides / instead of a
> trace file ?
>
>

In PL/SQL, use the 'dbms_output.put_line()' function (after 'set serveroutput on size n'). In sqlplus, use the 'prompt' command. In triggers, use a 'debug' table (where you put messages to be retrieved by sqlplus later). In Java, use the 'printf()' function. In ... and so on. Received on Tue Oct 15 2002 - 17:39:57 CDT