Accessing Global Temporary Tables in Debugger

[jmcquilling]

Is there a way in PL/SQL Developer to access a Global Temporary Table in the debugger?

We are moving from Sybase to Oracle and use Temp tables a lot and would like to look at the data in the temp tables in the debugger.

Thanks

 

[Marco Kalter]

Table data that is restricted to the debug session is unfortunately not visible from anywhere.

 

[Claus Pedersen]

The data in a temp table is only visible to the current session only and will never be stored in the database.

The table structure is available for all sessions, but the data is strictly private for the individual session.

 

[vladzak]

Sybase is more like MSSQL (which is actually offspring,) and is very different conceptually. It's common to use temp tables in them, while in Oracle you seldom need them. If you try to blindly move your code from Sybase, prepare for all sorts of troubles with concurrency (their concurrency models are completely different) and efficiency (because what works well in Sybase doesn't necessarily will in Oracle, and vice-versa.)

I'd recommend that you familiarize yourself with Oracle Concepts manual first (and read it very thoroughly) and figure out all differences between it and Sybase and only after you understand them you can approach porting of your applications. Tom Kyte's books are also highly recommended.