ORA-22804 or PLS-453 attempting to access a remote object table using a user defined type (Doc ID 136352.1)

Last updated on MAY 07, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.5.0 to 8.1.7.4 [Release 8.0.5 to 8.1.7]
Information in this document applies to any platform.

Symptoms


You are trying to select, insert, or update a remote table that contains an
object type and it fails with one of the following errors:

ORA-22804 remote operations not permitted on object tables
or user defined type columns
PLS-453 remote operations not permitted on object tables
or user defined type columns

For example (where ora816.prod2.mycorp.com is a dblink created on your local
database and test1 has an object type column):

SQL> connect test_user/

SQL> insert into test1@ora816.prod2.mycorp.com values (9,'nine',(9/3))
*
ERROR at line 1:
ORA-22804: remote operations not permitted on object tables or user-defined
type columns



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms