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

RMAN-06906: backup of controlfile was cancelled

1 Answers

ORA-31651: communication error with master process - detaching job

1 Answers

CLSS-00003: unable to determine cluster name. type string

1 Answers

ORA-01136: specified size of file string (string blocks) is less than original size of string blocks

1 Answers

ORA-28182: cannot acquire Kerberos service ticket for client

1 Answers

ORA-27006: sbtremove returned error

1 Answers

PLS-01471: The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr)

1 Answers

RMAN-06478: WARNING: datafile copy 'string' cannot be found on disk

1 Answers

KUP-04040: file string in string not found

1 Answers

ORA-01913: EXCLUSIVE keyword expected

1 Answers

ORA-13374: SDO_MBR not supported for geodetic data

1 Answers

RMAN-08180: channel string: restore complete, elapsed time: string

1 Answers

For more Oracle Errors Interview Questions Click Here