Oracle Error Message
PLS-00960: RPCs cannot use parameters with schema-level object types in this release
Reason for the Error
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_rec@rpc; — illegal attempt to use type my_rec
Solution
Use only PL/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.
