ORA-22903: MULTISET expression not allowed



ORA-22903: MULTISET expression not allowed..

Answer / guest

Cause: MULTISET expressions are allowed only inside a CAST
to a nested table or VARRAY type.

Action: put the MULTISET(subquery) expression inside a CAST
to a nested table or VARRAY type.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-39117: Type needed to create table is not included in this operation. Failing sql is: string

1 Answers  


ORA-32031: illegal reference of a query name in WITH clause

2 Answers  


ORA-02375: conversion error loading table string.string partition string

1 Answers  


NID-00145: nls subsystem initialization failure for product=string, facility=string

1 Answers  


ORA-16645: unexpected new instance interrupted current operation

1 Answers  






PCC-02020: Preprocessor error at line number, column number, file string:

1 Answers  


IMP-00001: respond with either string, string, RETURN or '.' to quit

1 Answers  


PLS-01707: In positioned DELETE or UPDATE statement, table must be identified in specification of cursor

1 Answers  


ORA-08187: snapshot expression not allowed here

1 Answers  


ORA-31692: The following SQL statement failed trying to insert a row into the Master table: string

1 Answers  


ORA-26051: internal error parsing packed decimal format string

1 Answers  


ORA-38303: invalid option for PURGE TABLESPACE

1 Answers  


Categories