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!

Ajax call returned server error ORA-01403: no data found for .

mehpadDec 1 2017 — edited Dec 2 2017

Hi,

I have an IG (Apex 5.1.1) and my query has a filter that uses values in text fields i.e. select * from table where org_id = P1_ORG_ID and username = P1_USERNAME

The 2 text fields were set to Static Values.

So I edit one column and then when I save, it gives me this error:

But, when I hard code the where clause in my query select * from table where org_id = 123 and username = 'JSMITH', it successfully saves!

I don't know if this is a bug. Is there any workaround for this? Please help!

Thank you in advance..

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 30 2017

Added on Dec 1 2017

#apex, #apex-discussions, #interactive-grid

4 comments

884 views