Test 1
I set my R13 to make no connection at start up:
1 In Define Connections window (under Imported Fixed Users in my case) make sure no Connection is checked: Uncheck Connect on Startup
2 Use Log off button in Session ribbon and select All
3 Close all windows (so that they won't reopen on next start up) and exit R13.
4 Start R13 and when prompted to make a connection click Cancel
5 Using the ribbon, select File-New-Command Window
6 Go to Session-Log on and select a connection
7 At the SQL prompt execute: EXEC dbms_output.put_line ('This is a test');
8 You get: PL/SQL procedure successfully completed
Test 2
1 Use Log off button in Session ribbon and select All
2 In Define Connections window select a Connection to connect on Startup
3 Close all windows (so that they won't reopen on next start up) and exit R13.
4 Start R13 (you won't get prompted to connect and no window is re-opened)
5 Using the ribbon, select File-New-Command Window
6 At the SQL prompt execute: EXEC dbms_output.put_line ('This is a test');
7 You get the correct result displayed: This is a test
8 Go to Session-Log off and select All
9 Go to Session-Log on and select the same connection
10 At the SQL prompt execute: EXEC dbms_output.put_line ('This is a test');
11 You get: PL/SQL procedure successfully completed
12 You have to manually enter: SET SERVEROUTPUT ON [UNLIMITED]
To answer your question:
About the items 8 and 9 in Test 2: you can log off and Log on either way, and the result is the same:
* Session-Log off
* On the status bar of the Command Window: Click on the Connection Indicator and from the drop-down menu select disconnect
* From the SQL prompt type: Disconnect
* After you are disconnected, use either way to connect: Session-Log on, Connection Indicator on the status bar, manually from the SQL prompt, or skip the connection and re-execute the dbms_output command right after the disconnect command.
Test 3
Item 1 to Item 7: Same as in Test 2
8 From the SQL prompt type: disconnect.
9 R13 responds: Not logged on
10 However, the Connection Indicator on the status bar still shows the connection as well as the colour assigned to this connection.
11 Type the SQL*Plus command: Show User, and you get the user that is connected
12 You don't need to reconnect, just execute the command: EXEC dbms_output.put_line ('This is a test') and the text is not displayed.
Hope this helps
Thank you
