Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: writing records while doing select.
A session can only do one thing at once, unless you thread a call to
another method that is posted when the select completes. You would
have to write your procedure as an external procedure, or better yet, a
Java stored procedure in the database that your Crytsal Report invokes
as its data source. You could also use DBM_JOBS as your thread source.
That sounds really ugly, though. Talk about re-inventing the wheel...
Why not just turn on trace? It captures the exact time statement is run in microseconds relative to an arbitrary epoch. You can always parse the trace file later and do the math to get the difference (and associated run time).
Regards,
Steve Received on Mon May 01 2006 - 12:18:15 CDT