PLS-00960: RPCs cannot use parameters with schema-level object types in this release

PLS-00960: RPCs cannot use parameters with schema-level object types in this release

Cause: Schema-level object types, or types which recursively use such types, were used in an RPC, which is not permitted. For example: create type foo as object (...) create package my_pack is type my_rec is record(v foo); -- on a remote server: x my_pack.my_recrpc; -- illegal attempt to use type my_rec

Action: Use only PL or SQL-defined types in RPC calls. It may be necessary to add extra code to element-wise copy schema-level types into local types in order to move such data through an RPC.

No comments:

Post a Comment