1

I'm using Oracle SQL Developer version: enter image description here

When i try execute a SELECT in a Oracle 9i database i got the following error:

enter image description here

I have PL/SQL DEVELOPER installed in my machine and i can SELECT this same table normally in same database (Oracle 9i) but with Oracle SQL Developer i got the error.

SOLUTION I downloaded the driver ojdbc6.jar and set in Advanced Tool Oracle SQL Developer. Everything works fine.

Improve this question
12
  • Um... no, the error does not appear when you "try to connect". What you got is a normal Oracle error message, you wouldn't get that if you weren't able to connect in the first place. Just guessing, but I assume you get that error AFTER you connect, when you try to run a SELECT statement or something similar. If you work in information technology you should know you must be precise, especially when you ask for help. The issue is probably caused by a Java driver incompatibility with your very old Oracle version. See community.oracle.com/thread/3638852 for possible solution. Commented Aug 2, 2017 at 14:40
  • Exactly, this error occurs in SELECT not in CONNECT, i already edited my post. Commented Aug 2, 2017 at 14:45
  • I have a Instant Client 11.2 and tried: Tools > Preferences > Database > Advanced to point to an 11.2.0.3 Oracle client (either full or instant). But i got the same error. Commented Aug 2, 2017 at 14:46
  • I don't know much more than I already said (never had to work with Oracle 9). Lucky for you, Jeffy Smith, the program manager for SQL Developer at Oracle, is a contributor to Stack Overflow and he often jumps in to help on SQL Developer questions. Give him a few hours to find your post and respond to it! You did very well to tag your question properly with the oracle-sqldeveloper tag. Good luck! Commented Aug 2, 2017 at 14:59
  • What is the SQL statement you're trying to run? Commented Aug 2, 2017 at 16:11

1 Answer 1

Reset to default
2

SOLUTION

I downloaded the driver ojdbc6.jar and set in Oracle SQL Developer. Everything works fine.

enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

You can download ojdbc6.jar from Oracle at oracle.com/technetwork/apps-tech/jdbc-112010-090769.html

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.