In SQL Navigator version 6.1, it's not possible to turn off Automatic Disconnect in sql script as is possible to do in SQL Navigator version 5.5.
To reproduce the issue please follow the steps below (in both SQL Navigator versions)
1. Paste this script into the sql editor (changing schemas, passwords and dblinks)
CONNECT USER1/PASSWORD@DATABASE
SELECT * FROM dual
/
CONNECT USER2/PASSWORD@DATABASE
SELECT * FROM dual
/
CONNECT USER3/PASSWORD@DATABASE
SELECT * FROM dual
/
2. Select all lines in the script and press F9
3. Compare 'Current session' combo box and task bar on both SQL Navigator.
Version 5.5 has the correct behaviour. It only allows to connect and retrieve data which will be displayed in the spool tab.
WORKAROUND:
None
STATUS:
Waiting for fix in a future release of SQL Navigator for Oracle
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy