CODEWITHSUNDEEP
oracle-databaseoracle11goracle-apex
Zubaria Ashraf
Zubaria Ashraf

Reputation: 1

How to solve this error of Oracle apex- 1403-no data found

I am new at oracle apex. just a beginner try to make an application using tutorials. But I got error when i create a report form and click on edit icon then 1403 error occurs. I'm doings all the things right. And table has data also. it is not empty.

enter image description here

Upvotes: 0

Views: 4814

Answers (2)

Waggers
Waggers

Reputation: 621

I've come across this a few times too, and haven't managed to get to the bottom of it. The only solution I've found is to create a new form page from scratch and link to that one instead, and delete the old one. Absolutely everything on the page can be the same, the new one will work and the old one doesn't.

I haven't seen a bug or known issue filed about this but it's very hard to replicate on demand - it seems to happen every so often for no reason that I can discern at present.

Upvotes: 0

Scott
Scott

Reputation: 5035

No data found probably relates to a problem with the automatic row process not returning results. While there may be data, the page item you refer to in the where clause may not be populated as expected.

Check your session state to see if a value is present, and the url used to open the page to ensure a value was sent to the page, eg: ./ords/f?p=102:31:14107262841235::NO:RP:P31_IDENTITY_ID:582708

Upvotes: 1

Related Questions