Home » SQL & PL/SQL » SQL & PL/SQL » How to know the status of sql batch processing trhough pl/sql?
How to know the status of sql batch processing trhough pl/sql? [message #223682] Sat, 10 March 2007 06:18 Go to next message
fazal_haq2001
Messages: 35
Registered: July 2006
Location: India
Member
Hi friends,
I done one batch file to execute one procedure from oracle.
and i schedule it through schedule task.Its a lengthy process and took some time to finish..
Is there any way to know the status of that batch processing when the process is on active through pl/sql..

Regards,
Fazal...
Re: How to know the status of sql batch processing trhough pl/sql? [message #223726 is a reply to message #223682] Sat, 10 March 2007 14:12 Go to previous message
gintsp
Messages: 118
Registered: February 2007
Senior Member
Instrument your code - one possibility is to use built in dbms_application_info package see more http://oracleandy.blogspot.com/2006/09/if-only.html

Gints Plivna
http://www.gplivna.eu
Previous Topic: Spooling out of order
Next Topic: run a script
Goto Forum:
  


Current Time: Sat Feb 15 17:06:11 CST 2025