Toad World® Forums

Open session bug in Beta

When I started up the new beta and entered a connection I get the following error

ORA-06550: line 314, column 33:
PLS-00103: Encountered the symbol "<
SELECT do.owner
FROM sys.all_o" when expecting one of the following:

. ( * @ % & = - + ; < / > at in mod not rem
<an exponent (**)> <> or != or ~= >= <= <> and or like
between is null is not || is dangling

and while I see the list of tables in the schema plain, any attempt to asses them fails with an ORA-00942 error. I am attempting to connect to an Oracle 8i database. If I connect to an Oracle 18 or Oracle 10 database everything works fine

Oracle 8i! :open_mouth:

I introduced a Q-quote into our new connection queries. While technically we don't support that dinosaur, the Q-quote is easily removed. Check out the next beta and I think it should be fixed for you.

Thank you, i can't wait to dump 8i and were just waiting until the contracts are signed for us to upgrade to a modern version.
Can you still keep the Q-quote but check for the version before you run the query and run the one without if it's un unsupported version. Thanks