This content has been marked as final. Show 4 replies
FRM-40301: Query caused no records to be retrieved. Re-enter.Possible reasons for this error.
- Table is not having entry.
- The search criteria which you are entering is not having any data in table.
- Any list item/checkbox/radio item (added) is having not having any values which is in the table.
Bring up the "Display Error" screen (10g: Shift + Ctrl + E or 6i: Shift + F1) and copy the SQL Query to SQLPlus and run there. Typically, this will show you why you are getting no rows returned.
Hope this helps,
If someone's response is helpful or correct, please mark it accordingly.