Re: Q: DBMS_OUTPUT display while processing?

Rauno Seppanen <rauno.seppanen_at_icon.fi> wrote in message news:5LFs3.317$TI.769_at_read2.inet.fi...
> >>> one option that works very well is the dbms_application_info. this
> >>allows you to set values in the v$session table (to tell where you are)
> and in
> >>8.0 and up, to put many rows in the V$SESSION_LONGOP table with the
> >>> dbms_application_info.set_session_longops procedure. these rows are
> >>visible immediately (no commit needed) so they are perfect for
monitoring
> >>long running procedures from any terminal (a simple query shows the
status
> of a
> >>long running procedure that has calls to dbms_application_info in
it)....
> >>>
> That would be very useful also in 7.x versions. Do you think that it is
> possible somehow to get both V$SESSION_LONGOP table and the new
> dbms_application_info package into 7.2 database. We have also this 8.0
> version but we can't use that version yet because our client is not ready
> for it (and it'll take years until they are). So it would be used only
> during developing of programs.
>
> Rauno

This is the situation with many customers but be aware that 7.3 will be desupported on 31 December 1999...

Finn Received on Fri Aug 13 1999 - 23:05:03 CEST