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

Last updated on AUGUST 30, 2023

Applies to:

Symptoms

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.

Changes

Cause

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