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-04022: nowait requested, but had to wait to lock dictionary object
ORA-00703: maximum number of row cache instance locks exceeded
NNL-00413: Total response time: string
ORA-01942: IDENTIFIED BY and EXTERNALLY cannot both be specified
NZE-29119: Cannot import certificate.
ORA-02299: cannot validate (string.string) - duplicate keys found
NNL-00006: timeout, server is not responding
ORA-28601: invalid [no]MINIMIZE option
ORA-38310: cannot purge tablespace for other users
ORA-00200: controlfile could not be created
NNF-00002: Invalid value passed to function call
ORA-02001: user SYS is not permitted to create indexes with freelist groups