PLS-00960: RPCs cannot use variables with schema level user-defined types in this release

Cause: Schema level user-defined types, or types which recursively use such types, cannot be used in RPCs. For example: 

create type foo as object (...) 

create package my_pack is 

type my_tab is table of foo; 

-- on a remote server: 

x my_pack.my_tab@rpc; -- illegal attempt to use type my_tab

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

Back to previous menu

https://support.oracle.com/

http://www.oracle.com/