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!

tabular form no data found error

Alexandra RobinNov 16 2009 — edited Nov 17 2009
I want to use a tabular form in a region within another form so that the user can add a list of items affected by the information in the main part of the form. I created a seperate table to hold the values of the tabular form that includes a field for the form number to which the tabular form will refer and will create an LOV for the item/description to handle the select list for the item/description fields . In other words, here's a shortened example of my tables:

MY_MAIN_FORM_TABLE
ECR #
Dept #
Manager Name

MY_TABULAR_FORM_TABLE
ECR #
Item #
Item Description

I will make the tabular form display conditional with a button b/c there will not always be items associated (user will click button when needs to add items). My problem is that when using the Add Row button to start adding items I get the ORA-01403 - Unable to fetch row error because there is nothing yet in the table. I can add a bogus record to the table but I don't think I should have to. Also, I have to figure out how to auto-populate the ECR# field in MY_TABULAR_FORM_TABLE with the ECR# of the associated main form.

Maybe this is not the best way to handle this so if you have other suggestions, I'd love to hear. THANK YOU!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2009
Added on Nov 16 2009
33 comments
2,471 views