Re: stored procedure

"xueyang" <xueyangy_at_singnet.com.sg> wrote...
> Hi,
>
> One question, If i use dbms_output.put_line in a stored procedure, where i
> can find the output?
>
> Thanks in advance.
>

Hi,
just use something like 'SET SERVEROUTPUT ON SIZE 100000' in the session that will call the stored procedure. After that, execute the procedure. The output will come up when the procedure comes to end.

hth,
Guido Received on Mon Sep 23 2002 - 02:28:37 CDT