PLS-00960: RPCs cannot use variables with schema level
user-defined types in this release
- 1 Answers
- 6367 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-19707: invalid record block number - string
ORA-26027: unique index string.string partition string initially in unusable state
ORA-02295: found more than one enable/disable clause for constraint
ORA-24358: OCIBindObject not invoked for a Object type or Reference
ORA-39104: cannot call this function from a SQL parallel query slave process
TNS-01041: %s parameter "string" set to string
ORA-12483: label not in OS system accreditation range
NID-00403: DBNEWID - Completed with validation errors.
ORA-38488: attribute set already assigned to the column storing expressions
IMG-00516: default channel out of range
ORA-33022: (XSAGDNGL10) The measure dimension workspace object must be a TEXT or ID base dimension that does not dimension AGGMAP workspace object, but is in the same analytic workspace.
PLS-00247: LIBRARY name must be specified
Oracle Errors 
