Select * from Global Temporary Table while testing a Procedure

et

Member
hi,
is there a way to have a look at the rows of an Oracle 9i Global temporary table (like watch variables)while im stepping throug a procedure where inserts made in this temporary table?
I try the "dual session" preference to take care that the session-id in the sql-window is the same as in the test-window
...but i can run the
select * from GT_Table ;
only after the END of the procedure -
is there another way?
thanks for any reply et.
 
No, this is not possible. The debugger "holds" the session that creates the records in the temporary table, so this session cannot be used to access the data.

------------------
Marco Kalter
Allround Automations
 
Back
Top