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! |