CODEWITHSUNDEEP
oracle-databaseoracle-sqldeveloper
Paulina
Paulina

Reputation: 21

ORA-01460 unimplemented or unreasonable conversion requested sqldeveloper

I am connected to a database using SQL Developer.

I can make queries, but to "open description in popup" on a stored procedure, it throws an "Object not found" message. If I try to open the browser options: Views, Procedures, Functions, Materialized Views, it throws the error 

 ORA-01460 unimplemented or unreasonable conversion requested".

Upvotes: 2

Views: 16320

Answers (1)

thatjeffsmith
thatjeffsmith

Reputation: 22437

Your version of SQL Developer is using a JDBC driver (12.2.1.0) that is speaking a dialect that your version of the database, does not understand.

You can try to use a thick client connection - where you would configure SQL Developer to use an 11.2.0.3 Instant Client to make the connection - and that might help - but it depends on just how old your database is.

Your other option is to use an older version of SQL Developer which ships with an older version of the JDBC driver.

Ideally you'll want to keep your databases updated to modern versions. That's the ultimate and hardest solution though.

Upvotes: 2

Related Questions