PLS-00960: RPCs cannot use variables with schema level
user-defined types in this release
- 1 Answers
- 5903 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 |
NNL-01073: Administrative region description: string
TNS-01186: Client connection was dropped based on a filtering rule
ORA-39040: Schema expression "string" must identify exactly one schema.
ORA-10571: Test recovery canceled
RMAN-01006: error signalled during parse
LSX-00258: invalid escape character
ORA-27103: internal error
RMAN-06062: can not backup SPFILE because the instance was not started with SPFILE
ORA-12424: length exceeds binary label size
ORA-32322: PCT refresh of "string"."string" not allowed the sequence of DMLs/PMOPs
ORA-15002: parameter LOCK_NAME_SPACE exceeds limit of string characters
ORA-16176: background dictionary build cannot be running
Oracle Errors 
