Commit Question
"Leo Drobnis" <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
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