My Oracle Support Banner

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

Last updated on APRIL 26, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 8.0.3.0 to 8.1.7.4 [Release 8.0.3 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

To view full details, 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 a vibrant support community of peers and Oracle experts.