Explain plan error: ORA-22905: cannot access rows from a non-nested table item
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: