My Oracle Support Banner

ORA-00942 Received When Preparedstatement.setClob(ResultSet.getClob()) Across Database Instances (Doc ID 2498795.1)

Last updated on AUGUST 30, 2023

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.