ORA-22905: cannot access rows from a non-nested table item
573929Nov 5 2007 — edited Nov 5 2007Hi all,
In the region source, i am using the sql. This sql to retrive the reports. I am using a package in inside the sql.
"Select ...... from ...... where ..... and d.LCT_HOLIDEX in (select LOCATION_CODE from TABLE (iconnect.ic_get_details.get_secondary_loc_list(:F169_GLOBAL_id)))"
Its display the error in parameter(:F169_GLOBAL_id).
I receive the following error message:
"Query cannot be parsed within the Builder. If you believe your query is syntactically correct, check the ''generic columns'' checkbox below the region source to proceed without parsing. ORA-22905: cannot access rows from a non-nested table item."
How to solve this?