This content has been marked as final. Show 4 replies
you added a column in detail .. ARe you sure this column is exist in your table.
I think this column is not in your table due to this error showing.
i had checked but
not find anything
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.