ORA-01403 no_data_found when saving the record in the custom form
MikeLiSep 20 2009 — edited Sep 20 2009My custom form has 2 windows with 3 blocks. The first window has the BATCH block while the second window contains the HEADERS and LINES blocks. User go to first window, enter the batch info and save the record with no issue. Now user go to second window, enter the header info and save. Now we have the ORA-01403 no_data_found error. My custom form only have few SQLs and I put exception blocks on all of them but no_data_found still shows.
Besides explicitly-used SQL statements, I wonder where else may have triggered the NO_DATA_FOUND error?
Thanks, Mike.