My Oracle Support Banner

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.

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

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
Symptoms
Changes
Cause
Solution
References


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