Re: How to use the DBMS_OUTPUT package ?

From: <efflerch_at_my-deja.com>
Date: Wed, 22 Mar 2000 11:29:59 GMT
Message-ID: <8baarb$i5q$1@nnrp1.deja.com>

In article <38D8937E.FB495C05_at_fisystem.fr>, Alain Kreienbuhl <akreienb_at_fisystem.fr> wrote:
> Hello,
>
> (Sorry for this) But how do you use the DBMS_OUTPUT.
>
> Thanks.
>
> Alain.
>
>

par example

dbms_output.put_line ('Text : '||variable);

in SQL+ you must type in " SET SERVEROUTPUT ON" to see what dbms_output writes out

in TOAD you have to open a DBMS OUTPUT Window in the same session you use dbms_output

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 22 2000 - 05:29:59 CST