Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: What's a good way to do progress indicators?

Re: What's a good way to do progress indicators?

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: 2000/06/21
Message-ID: <39506BF7.9F898075@0800-einwahl.de>#1/1

Hi Michael,

  1. you could use utl_file for writing to a server-side file.
  2. you can use the dbms_application_info to set an info line that is visible in V$SESSION which you would inquire by OEM and similar tools.

Martin

Michael Bell wrote:
>
> A long-running PL/SQL procedure needs to make periodic progress
> notifications (without committing). What's a good way to notify client
> programs of progress?
> --Michael
Received on Wed Jun 21 2000 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US