Recent content by dom999v

Thanks for the info, and interesting to know that Oracle starts a transaction when you select over a db link.

Not really a bug, but if I do a select on a remote table e.g. select sysdate from dual@remotedb, then the commit/rollback icons are activated in the toolbar. My current version is 5.0.1.480 but its been there for the last few versions at least. Thanks Dom

Thanks for the reply. It was in an SQL window. I tried as suggested to surround it with begin and end but that didn't make any difference (although I would have thought this was un-necessary anyway - what if you want to format SQL as oppose to PL/SQL).

I get the same message ('could not parse text') when I try to use the Beautifier on the following code select sysdate from dual; Not sure why, any clues?