6 Replies Latest reply on May 22, 2014 5:45 AM by roobie

Tabular Form raised No Data Found and unhandled user-defined exception

roobie May 19, 2014 11:52 AM

Hi all,

I've been getting this error after introducing some javascript/jquery code to dynamically disable/enable cells in the Tabular Form when the page loads. I am not sure why especially iti s javascript code not SQL or PL/SQL. The javascript/jquery code works as disired but when the page is submitted APEX raises these errors.

Please advise if disabling/enabling fields in Tabular Form causes such errors to occur. Is this operation not allowed in Tabular Form at all?

Thanks

1. Re: Tabular Form raised No Data Found and unhandled user-defined exception

Pars May 19, 2014 1:04 PM (in response to roobie)

solution for disable value get submitted in tabular form without error
try following:
Create Dynamic action On page zero or current tabular from page
Event:Before page Submit
Condition: No condition
Action:Execute Javascript Code
Code:$(':disabled').removeAttr('disabled');
Remaining things kept default..
Hope this solve your submit problem.

Regards'
Pars.
Like Show 0 Likes(0)

Actions
2. Re: Tabular Form raised No Data Found and unhandled user-defined exception

roobie May 19, 2014 11:10 PM (in response to Pars)

Hi Pars,

Thought about that undo the disablement as well but wasn't sure how to do that and if it works.

Will give it a crack and let you know how I went.

Cheers!
Like Show 0 Likes(0)

Actions
3. Re: Tabular Form raised No Data Found and unhandled user-defined exception

roobie May 19, 2014 11:17 PM (in response to roobie)

Hi Pars,

That works for me. Thanks for your help.

Cheers!
Like Show 0 Likes(0)

Actions
4. Re: Tabular Form raised No Data Found and unhandled user-defined exception

roobie May 22, 2014 5:06 AM (in response to roobie)
Hi,

I am still getting this error in a different scenario as follow:

When the page loads create 10 empty rows using apex.widget.tabular.addRow()
Save 4 records in the database (all good so far)
Enter invalid data a new row (5th) and hit Save
Validation fires displaying intended error messages
Empty rows disappear
The following error messages display:
report error:
ORA-01403: no data found
ORA-06510: PL/SQL: unhandled user-defined exception

There are 2 issues here.
1) The errror
2) Empty rows are not displayed (not sure if the error prevents my code creating the empty rows again?)

The code "$(':disabled').removeAttr('disabled');" works for me in my previous scenario.

Please advise in which Dynamic Action event can I put the code in so that I can undo the disabled items?

Thanks in advance!
Like Show 0 Likes(0)

Actions
5. Re: Tabular Form raised No Data Found and unhandled user-defined exception

Pars May 22, 2014 5:33 AM (in response to roobie)

Roobie,
start a new question so that other people also suggest some information
this thread is answered so otherones ignore to look into thread..

roobie wrote:

The code "$(':disabled').removeAttr('disabled');" works for me in my previous scenario.

Please advise in which Dynamic Action event can I put the code in so that I can undo the disabled items?

previous DA works for only for enable disabled item before page submit.
now you are creating 10 empty rows on page loads,
in this case error displays as no data found message happen in my case also
but not found solution for me also...
Like Show 0 Likes(0)

Actions
6. Re: Tabular Form raised No Data Found and unhandled user-defined exception

roobie May 22, 2014 5:45 AM (in response to Pars)

Thanks Pars. Will create a new thread. Hope will get a solution for this ASAP as this has become critical to me now.
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.