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



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

Answer / guest

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 PLSQL 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.

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-40273: invalid model type string for Adaptive Bayes Network algorithm

1 Answers  


RMAN-08018: channel string: starting archive log restore to user-specified destination

1 Answers  


ORA-19203: Error occurred in DBMS_XMLGEN processingstring

1 Answers  


DRG-11532: error reading through end of line string for file string

1 Answers  


ORA-28652: overflow segment attributes cannot be specified

1 Answers  


ORA-01677: standby file name convert parameters differ from other instance

1 Answers  


ORA-04019: SCN scheme incompatible with other instances

1 Answers  


ORA-07283: sksaprd: invalid volume size for archive destination.

1 Answers  


ORA-22921: length of input buffer is smaller than amount requested

1 Answers  


TNS-01094: %s * number

1 Answers  


ORA-21526: initialization failed

1 Answers  


ORA-23609: unable to find directory object for directory string

1 Answers  


Categories