ORA-00942 Received When Preparedstatement.setClob(ResultSet.getClob()) Across Database Instances
(Doc ID 2498795.1)
Last updated on MAY 08, 2020
Applies to:JDBC - Version 10.2.0 and later
Information in this document applies to any platform.
When selecting CLOB data from a table in one database instance and inserting it using a prepareStatement with ps.setClob(1, rs.getClob(1)); in a different database instance, you may get an "ORA-00942: table or view does not exist" error.
The table script is :
it works fine.
And if you SELECT and INSERT the data into the table from the same database instance, it works fine too. The error shows only when working between tables from two different database instances.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document