Impromptu - reporting tool & sys.dbms_ijob.remove

[Quoted] Anyone familar enough with Impromptu to know if it creates a process that has the following statement in it: 'begin sys.dbms_ijob.remove(:job); end; ??

We have a remote site accessing our database over a T1 and they have a local hot table on their PC's which is also used in the query *BUT* the only thing showing up on our end (via the Top Session Monitor) is the SELECT statement (and not their local hot table).

I guess I am wondering what Impromtu/Impromptu is doing? Will it always kick off another process (dbms_jobs or dbms_ijobs?)? Why doesn't the full SELECT statement show?

Thanks!

-Mike Received on Wed Jun 03 1998 - 00:00:00 CEST