PLS-00960: RPCs cannot use variables with schema level
user-defined types in this release
- 1 Answers
- 6324 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-00544: Displays operations statistics
ORA-09925: Unable to create audit trail file
SQL*Loader-00816: error creating temporary directory object string for file string
ORA-12168: TNS:Unable to contact LDAP Directory Server
PCC-00115: Array required here
ORA-16727: resource guard cannot close database
PCC-02342: using WHERE CURRENT OF on cursor defined without FOR UPDATE clause
ORA-13438: GeoRaster metadata pyramid type error
TNS-01404: Max Load: string
ORA-01685: max # extents (string) reached in index string.string partition string
ORA-32627: illegal pattern in MODEL FOR LIKE loop
ORA-12540: TNS:internal limit restriction exceeded
Oracle Errors 
