RE: Commit Question

Are you running F5 in the main Toad session or in its own session (Options -> Oracle -> Transactions -> Execute scripts in Toad session)?  If that's not checked, you're performing a commit in a different session than the main Toad session.

Greg

From: [email protected] [mailto:[email protected]] On Behalf Of Leo Drobnis
Sent: Friday, October 28, 2011 11:11 AM
To: [email protected]
Cc: Leo Korin
Subject: [toad] Commit Question




A co-worker of mine puzzled me a bit.

He installed TOAD 11.0.0.116.  When he runs a commit (typed in the editor) and uses either F5 or execute as script, the commit does not actually commit into the DB, even thought the committed message shows up in TOAD.  When F9 or execute statement is clicked, commit works fine.

According to him, TOAD 10.6.0.42 worked just fine.  The actual commit button works as well.

Below is the spooled SQL.

I am very curious as to what is going on.

F5 COMMIT:

----------------------------------
Timestamp: 11:04:22.947
Connect: LKORIN@QACAN

----------------------------------
Session: LKORIN@QACAN
Timestamp: 11:04:23.697
BEGIN DBMS_OUTPUT.ENABLE(buffer_size => NULL); END;

----------------------------------
Session: LKORIN@QACAN
Timestamp: 11:04:23.775
select PARAMETER,VALUE from nls_session_parameters where PARAMETER in('NLS_NUMERIC_CHARACTERS','NLS_DATE_FORMAT','NLS_CURRENCY')

----------------------------------
Session: LKORIN@QACAN
Timestamp: 11:04:23.807
select to_char(9,'9C') from dual

----------------------------------
Session: LKORIN@QACAN
Timestamp: 11:04:23.838
commit

----------------------------------
Session: LKORIN@QACAN
Timestamp: 11:04:23.838
begin dbms_output.get_line(line => :line, status => :status); end;
:line(LONG,OUT)=<NULL>
:status(INTEGER,OUT)=<NULL>

----------------------------------
Session: LKORIN@QACAN
Timestamp: 11:04:23.838
begin :id := sys.dbms_transaction.local_transaction_id; end;
:id(VARCHAR[0],OUT)=<NULL>

----------------------------------
Timestamp: 11:04:23.853
Disconnect: LKORIN@QACAN


F9 COMMIT:

----------------------------------
Session: LKORIN@QACAN
Timestamp: 11:04:59.916
Commit