How to fix the Oracle error PLS-00960: RPCs cannot use parameters with schema-level object types in this release?

In this post, you’ll learn more about the Oracle ErrorPLS-00960: RPCs cannot use parameters with schema-level object types in this release with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

How to fix the Error PLS-00960: RPCs cannot use parameters with schema-level object types in this release ?

You can fix this error in Oracle by following the below steps

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.