ORA-22900: the SELECT list item of THE subquery is not a collection type

ORA-22900: the SELECT list item of THE subquery is not a
collection type

Question Posted / guest

1 Answers
3423 Views
I also Faced
E-Mail Answers

ORA-22900: the SELECT list item of THE subquery is not a collection type..

Answer / guest

Cause: The THE subquery must SELECT a nested table or VARRAY
item.

Action: change the subquery to SELECT a nested table or
VARRAY item.

Please add more information about this Error

Is This Answer Correct ?

0 Yes

0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-02031: no ROWID for fixed tables or for external-organized tables

1 Answers

ORA-01676: standby file name convert of 'string' exceeds maximum length of string

1 Answers

ORA-30157: An invalid argument was given to operating system call

1 Answers

ORA-06741: TLI Driver: unable to open protocol device

1 Answers

ORA-28027: privileged database links may be used by global users

1 Answers

ORA-31051: Requested access privileges not supported

1 Answers

O2I-00129: No Java file specified

1 Answers

ORA-29269: HTTP server error string

1 Answers

PLS-00305: previous use of 'string' (at line string) conflicts with this use

1 Answers

ORA-22992: cannot use LOB locators selected from remote tables

1 Answers

ORA-19332: Invalid column in the CREATE_DBURI operator

1 Answers

RMAN-06226: Automatic instance removed

1 Answers

For more Oracle Errors Interview Questions Click Here