oracle ORA-01460 未实现或不合理的转换请求 sqldeveloper
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/31596387/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
ORA-01460 unimplemented or unreasonable conversion requested sqldeveloper
提问by Paulina
I am connected to a database using SQL Developer.
我使用 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
我可以进行查询，但是对于open description in popup存储过程的“ Object not found” ，它会抛出“ ”消息。如果我尝试打开浏览器选项：视图、过程、函数、物化视图，它会抛出错误
ORA-01460 unimplemented or unreasonable conversion requested".
ORA-01460 unimplemented or unreasonable conversion requested".
回答by thatjeffsmith
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.
您的 SQL Developer 版本正在使用 JDBC 驱动程序 (12.2.1.0)，该驱动程序使用您的数据库版本无法理解的方言。
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.
您可以尝试使用胖客户端连接 - 您可以将 SQL Developer 配置为使用 11.2.0.3 Instant Client 来建立连接 - 这可能会有所帮助 - 但这取决于您的数据库的年龄。
Your other option is to use an older version of SQL Developer which ships with an older version of the JDBC driver.
您的另一个选择是使用旧版本的 SQL Developer，它附带旧版本的 JDBC 驱动程序。
Ideally you'll want to keep your databases updated to modern versions. That's the ultimate and hardest solution though.
理想情况下，您希望将数据库更新为现代版本。不过，这是最终也是最难的解决方案。
