It looks to me like Toad’s parser doesn’t fully support COMMIT or ROLLBACK in the Editor window.
If I do this:
COMMIT COMMENT “my comment”
and then press F9, Toad will send “COMMIT”
This also comes into play with 2PC FORCE commands like
COMMIT FORCE ‘12.3.4567’
You can get around it by wrapping the commands in an anonymous block, but that seems kind of silly
BEGIN COMMIT FORCE ‘12.3.4567’; END;
Is this a hole, a bug or am I doing something wrong?