Skip to Main Content
Forums

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!

Validation fires resulting in report error: ORA-01403: no data found and ORA-06510: PL/SQL: unhandle

roobieMay 22 2014 — edited May 27 2014

Hi all,

I am getting this error in the scenario as follow:

  1. When the page loads create 10 empty rows using apex.widget.tabular.addRow()
  2. Save 4 records in the database (all good so far)
  3. Enter some valid data a new row (5th) and leave mandatory columns empty and hit Save
  4. Validation fires displaying the error messages as intended
  5. Empty rows disappear
  6. The following error messages display:

report error:

ORA-01403: no data found

ORA-06510: PL/SQL: unhandled user-defined exception

NOTE:  In 3. above some of the fields are disabled as they are not required for the record type being entered.

There are 2 issues here.

1) The error

2) Empty rows are not displayed (not sure if the error prevents my code creating the empty rows again?)

Has anyone got a solution for fixing or getting around this issue?

Thanks in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2014
Added on May 22 2014
#apex-discussions
2 comments
242 views