Many windows on same session

[rene.heusser]

I would like to run a function in a test windows and check the results in an SQL window without commiting the results.
How can I connect the SQL windows to the session in which the test windows is running?

Kind regards
Ren

 

[Marco Kalter]

The only way to accomplishg this is to use "Dual Session Mode" (Tools > Preferences > Oracle/Connection). This way all the SQL Windows, Test Windows, Command Windows, and so on share the same session. All DDL operations (compilation, altering, dropping, ...) are performed in a separate session (hence the term "dual").

 

[rene.heusser]

Dear Marco

Thanks for the advice.

Kind regards
Ren