Interested to Buy Any Domain ? << Click Here >> for more details...
PLS-00960: RPCs cannot use variables with schema level
user-defined types in this release
- 1 Answers
- 7037 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 |
IMP-00074: The constraints flagged by ALL_CONSTRAINTS.BAD will break in 2000 A.D.
ORA-12235: TNS:Failure to redirect to destination
TNS-00221: Pump Connections Total Data Bytes/Second
ORA-01196: file string is inconsistent due to a failed media recovery session
ORA-01531: a database already open by the instance
LSX-00240: bad float "~S"
EXP-00092: Unable to set NLS_NUMERIC_CHARACTERS to required defaults.
ORA-31054: The string operator cannot have an ancillary operator
PLS-00995: unhandled exception # string
ORA-28513: internal error in heterogeneous remote agent
DRG-11115: a value for string must be specified
PCC-00064: All uses of a given host variable must use identical indicator variables.
Oracle Errors 
