ORA-01722 invalid number during an Automated Row Fetch
100702Mar 7 2006 — edited Mar 14 2006To All,
I have an application that has a report page, an insert page and a update page. When my users search their application data, the page returns a hit. The primary key is then linked to the update page. When they click on the link they some times get an ORA-01722 invalid number during the Automated Row Fetch. But it is only some times.
The data is entered when the user's click on the "CREATE" button taking them to the insert page. When they click on the "SAVE" button I have a PL/SQL insert statement that inserts the data and generated the primay key by called the sequence number. So I know that the primary number be a number.
My update page uses a DML Fetch Mode of "Set Memory Cache On Fetch". My session state page item is set at the page level and I can see the value when I look at my session valables. I am doing a "On Load - Before Header" Processing Point and a "Once Per Page Visit" for the Run Process. There are no conditional processing or security for the update page.
I just do not understand why user's get the message some time and not all the time.
We are currently use HTMLDB v1.6.
I am at my ends witt. Any help would be appriciated.
Thanks,
Alan