Re: DBMS_OUTPUT Question

Roy,
Unfortunately, you can not do want you want using DBMS_OUTPUT. It will only return your output messages when the procedure is done.

However, there is a way to handle this. You can create a table to store the results in after each archive (be sure to commit before proceeding to the next archive job).

Mark Prebilic
PrebSon Consulting

rspeaker_at_my-deja.com wrote:

> 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 Wed Nov 03 1999 - 15:29:08 CST