Skip to Main Content

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!

How know which could caused an error?

Eslam_ElbyalyAug 6 2023

Hi.

I am on APEX 21.2.

I have an after submit process which has numerous number of select… into statements. And I am facing Error: ora-1422- Exact fetch returns more than requested number of rows.

As the error implies, one of those select… into statements causes the error. I see no debugger in APEX. And the error only shows the culprit “after-submit” process but does not say which line or statement causes the problem.

How can I know which one causes it?

This post has been answered by fac586 on Aug 6 2023
Jump to Answer
Comments
Post Details
Added on Aug 6 2023
4 comments
325 views