PLS-00960: RPCs cannot use variables with schema level
user-defined types in this release
- 1 Answers
- 6377 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-00206: error in writing (block string, # blocks string) of controlfile
ORA-28584: heterogeneous apply internal error
NNO-00623: setting auto-refresh retry interval to number seconds
ORA-28100: policy function schema string is invalid
TNS-01161: Spawn alias string was not found. Check listener parameter file
ORA-36652: (XSDUNION11) workspace object is not a string type dimension.
ORA-12476: least upper bound resulted in an invalid OS label
QSM-02016: clustered table in FROM list
ORA-15019: discovered duplicate path 'string' for 'string'
IMG-00604: unable to access destination image data
TNS-12677: Authentication service not supported by database link
ORA-00071: process number must be between 1 and string
Oracle Errors 
