SQL Performance (MOSC)

MOSC Banner

Explain plan error: ORA-22905: cannot access rows from a non-nested table item

in SQL Performance (MOSC) 5 commentsAnswered ✓

Hello All,

I am planning to get explain plan for the below statement from sql developer but it errors out with error "ORA-22905: cannot access rows from a non-nested table item". Can someone let me know the solution to this issue if it exists?

Definition of number_array (Schema Level):

TYPE number_array AS TABLE OF NUMBER;

Statement not working:

EXPLAIN PLAN SET STATEMENT_ID = '111'

  FOR

SELECT

  column_value

INTO :b1

FROM

  TABLE (:b89)

WHERE

  ROWNUM <=:b3;

Error: ORA-22905: cannot access rows from a non-nested table item

22905. 00000 - "cannot access rows from a non-nested table item"

Working statement:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center