PLS-00960: RPCs cannot use variables with schema level
user-defined types in this release
- 1 Answers
- 5885 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 |
PCC-02362: Host variable not declared within SQL DECLARE section
ORA-25100: TABLESPACE option can only be used with ALTER INDEX REBUILD
RMAN-06480: WARNING: archivelog 'string' cannot be found on disk
ORA-37006: (AWLISTALL04) number writers
ORA-29305: cannot point-in-time recover tablespace 'string'
RMAN-06178: datafile number not processed because file is offline
ORA-13367: wrong orientation for interior/exterior rings
ORA-02830: Segment could not be split - no free segments available
PLS-00712: illegal option for subprogram string
PLS-00142: duplicate external PARAMETER list specification in subprogram expression
PLS-00203: function DECODE must be called with at least 3 non-boolean arguments
NNL-00011: no server with name "string" exists
Oracle Errors 
