Restriction on Using User-Defined Types with a Remote Database
User-defined types (specifically, types declared with a SQL CREATE TYPE statement, as opposed to types declared within a PL/SQL package) are currently useful only within a single database. You cannot use a database link to do any of the following:
•Connect to a remote database to select, insert, or update a user-defined type or an object REF on a remote table
You can use the CREATE TYPE statement with the optional keyword OID to create a user-specified object identifier (OID) that allows an object type to be used in multiple databases. See the discussion on assigning an OID to an object type in the Oracle Database Data Cartridge Developer's Guide.
•Use database links within PL/SQL code to declare a local variable of a remote user-defined type
•Convey a user-defined type argument or return value in a PL/SQL remote procedure call.
Partager