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
3467 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

NPL-00312: attempt to put ASN.1 "UNIV" type with illegal tag string

1 Answers

TNS-00265: Navigator: Reloaded network configuration data

1 Answers

RMAN-08542: channel string: starting proxy archivelog backup at string

1 Answers

RMAN-06041: cannot switch file number to copy of file number

1 Answers

RMAN-06526: KEEP option cannot be used with incremental backup

1 Answers

NNL-00006: timeout, server is not responding

1 Answers

ORA-16044: destination string attribute cannot be specified at session level

1 Answers

TNS-00077: the argument field

1 Answers

NNF-01006: Attribute string not available

1 Answers

ORA-12702: invalid NLS parameter string used in SQL function

1 Answers

LSX-00125: "restriction" element is improperly defined

1 Answers

ORA-07800: slbtpd: invalid number

1 Answers

For more Oracle Errors Interview Questions Click Here