PLS-00960: RPCs cannot use variables with schema level
user-defined types in this release
- 1 Answers
- 6411 Views
- I also Faced
- E-Mail Answers
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 |
ORA-40273: invalid model type string for Adaptive Bayes Network algorithm
RMAN-08018: channel string: starting archive log restore to user-specified destination
ORA-19203: Error occurred in DBMS_XMLGEN processingstring
DRG-11532: error reading through end of line string for file string
ORA-28652: overflow segment attributes cannot be specified
ORA-01677: standby file name convert parameters differ from other instance
ORA-04019: SCN scheme incompatible with other instances
ORA-07283: sksaprd: invalid volume size for archive destination.
ORA-22921: length of input buffer is smaller than amount requested
TNS-01094: %s * number
ORA-21526: initialization failed
ORA-23609: unable to find directory object for directory string
Oracle Errors 
