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!

Exists (SQL Query returns at least one row) Bug?

952639Jul 29 2012 — edited Jul 30 2012

Hi @ all,

I've a problem with a Form-Page of my application. In the "Fetch row" process I've implemented an "Exists (SQL Query returns at least one row) Condition" with this SQL-Select Statement:

select pat_id from pat
where pat_id = :P5_pat_id

when i run the page I get this error message: "exact fetch returns more than requested number of rows". Running this statement in SQL Developer returns exactly one row. I don't understand why apex show me this error message?

Does anybody know this problem?

kind regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 27 2012

Added on Jul 29 2012

#apex, #apex-discussions

2 comments

598 views