Re: DBMS_OUTPUT Question

Roy,

Write the records to a table which you can query in another sqlplus session. Or have a session that reads from a dbms_pipe and send messages to it from your code.

All the messages from dbms_output always appear when the procedure finishes, that just the way the function works.

Cheers,

Peter N. Crompton
(Oracle Certified Professional)

Email : Peter_Crompton_at_pitchmark.demon.co.uk Web : http://www.pitchmark.demon.co.uk/

<rspeaker_at_my-deja.com> wrote in message news:7vq7a6$dua$1_at_nnrp1.deja.com...
> Hi,
>
> considering the following code snippet ....
>
> create or replace procedure VRU_ARCHIVE
> as
> v_start_time varchar2(20);
> v_end_time varchar2(20);
>
> BEGIN
>
> select to_char(sysdate,'MON DD,YYYY HH24:MI:SS') into v_start_time from
> dual;
>
> DBMS_OUTPUT.PUT_LINE('Beginning ARCHIVE1 Procedure at
> ||v_start_time||'.');
>
> ARCHIVE1;
>
> select to_char(sysdate,'MON DD,YYYY HH24:MI:SS') into v_end_time from
> dual;
>
> DBMS_OUTPUT.PUT_LINE('Finished ARCHIVE1 Procedure at
> '||v_end_time||'.');
>
>
>
>
> select to_char(sysdate,'MON DD,YYYY HH24:MI:SS') into v_start_time from
> dual;
>
> DBMS_OUTPUT.PUT_LINE('Beginning ARCHIVE2 Procedure at
> '||v_start_time||'.');
>
> ARCHIVE2;
>
> select to_char(sysdate,'MON DD,YYYY HH24:MI:SS') into v_end_time from
> dual;
>
> DBMS_OUTPUT.PUT_LINE('Finished VRU_TRANTABLE_ARCH Procedure at
> '||v_end_time||'.');
>
>
> END; -- Procedure VRU_ARCHIVE
>
>
> my output messages do not appear until the very end of the procedure,
> and then all at one time. The information stored in the variables is
> correct, but I would like to see it output to the screen progressively,
> so I know when ARCHIVE1 started, when it finished, when ARCHIVE2
> started, when it finished, etc. How can I do this?
>
> Thanks,
> Roy
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 04 1999 - 00:00:00 CET