APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

573929Nov 5 2007 — edited Nov 5 2007

Hi 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?

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 3 2007

Added on Nov 5 2007

#apex-discussions

6 comments

1,717 views