see data in debug mode of temporary table

[Donna]

Hello All,
help would be appreciated.

I am debugging a program that is using temporary global tables - that have been defined with 'on commit preserve rows'.
the question is how can I see the data of these tables while running in debug mode.
I have changed the prefrences - oracle connection - session mode - to be dual session.

Thanks in advance,
Donna.

 

[Marco Kalter]

You should be able to see the changes in a separate SQL Window. I assume this is not the case?

 

[Donna]

i am opening a separate window - but i can not see the changes

 

[patch]

IMHO you should be using single connection, because the data in the temporary table is only visible to the current session. Even with 'on commit preserve rows' it's still only visible to the current session.

regards,
Patrick

 

[Donna]

the problem with a single connection is that debugging is not possible in this mode

 

[Marco Kalter]

With Dual Session mode, the Test Window and SQL Window will use the same session. So after executing the test script you should be able to see the changes, unless they are rolled back.