How to display status in long PL/SQL jobs?

From: Zernan Martinez <zlm101_at_psu.edu>
Date: 1996/12/01
Message-ID: <32a0ef68.799755@news>#1/1

I have a PL/SQL or SQL block that executes a fair amount of time. It goes something like this. . .

.
.

select A, sum(B)
from TABLE1
group by A
.
.

There are about 100 different A's out in TABLE1 and it takes about 30 minutes for it to finish.

Can anybody show me a simple way of reporting the status of the query as it processes. Some thing like . . .

A=1 done
A=2 done
A=5 done

.
.
.

Job finished.

I'm looking for a SQL, PL/SQL, or Pro*C solution to this.

Thanks for any info.

Please respond to zlm101_at_psu.edu Received on Sun Dec 01 1996 - 00:00:00 CST