PLS-00570: different number of columns in the multiset and
cast expressions
Answer / guest
Cause: Number of columns in the collection returned by
MULTISET and the number of columns for the CAST type don't
match. For example: create type tab_obj as object (n
number); create type tab1 as table of tab_obj; create table
tab2 (col1 number, col2 number); select CAST(MULTISET(select
col1, col2 from tab2) as tab1) from tab2;
Action: none
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-06913: CMX: error during redirection of connection
ORA-14324: values being added already exist in DEFAULT partition
ORA-22291: Open LOBs exist at transaction commit time
SQL*Loader-00555: unrecognized processing option
NNC-00002: error listening on stream string
ORA-24354: number fetched too large to fit in COBOL display type buffer.
TNS-03602: Insufficient arguments. Usage: trcroute <address>
RMAN-08056: skipping datafile string because it has not changed
PLS-00736: user-declared operators are not allowed
ORA-24505: cannot change character set id on the handle
NCR-04010: NCRR: Unable to contact Oracle Names Server
ORA-07449: sc: usnewlock failed.