HELP? Tricky Progress tracking problem...!

Hi Group,

I've got the following problem. I have this frontend which executes a stored proc. Based on user-specified criteria, a dynamic single-insert statement is constructed by this stored proc and executed. However, I would like to be able to track the progress of the insert.

Since it's a single statement that's being executed, I can't just count the inserted records since these will only become available after the commit. I also have no other options of communicating back to the client and I hesitate to put up a bogus progress indicator.

So I thought I go round that and try to brake out of this thru a trigger, alas this also does not work.

Here's what I tried, I created an insert row-level trigger on the targettable with the sole purpose of updating a field in another table and incrementing it's value each time a record got inserted. Then, instead of calling the stored proc directly and have the statement block the client, I placed the call to the stored proc into the dbms_job queue for immediate execution. (Thinking that the update by a row-level trigger would be committed on every pass of the trigger, it being a row-level trigger). No go here either.

How come? or better, any way round this?

Raj Gabrielse Received on Fri Jul 09 1999 - 17:01:33 CDT