Re: Forms 6.0 and ORA-01403 errors

[Quoted] Hello Neil,

we have the same Problem on our 7.3.4 Database. It seems to look like the insert-statement is been cut, especially on tables with many columns.

ORACLE is telling us for months that they will fix the problem and send us a patch, but there happened nothing until now.

The problem does not appear at a 8.x Version of ORACLE RDBMS.

Unfortunately, we haven't found a work-around on this problem. Perhaps, somebody in the news-group knows such a work-around.

HTH Angelito

Neil W. Garside schrieb:
>
> Hi,
>
> I have a Forms 6.0 form based on an Oracle 7.3.4 table which displays
> the following problem: when I post an table insert or update I get
> a "FRM-40508 (or 40509 if updating): ORACLE error: unable to INSERT (or
> UPDATE) record." If I hit Shift + F1 to display the 'Database Error'
> dialog, the 'SQL Statement in error' box contains random, unreadable
> text (just symbols). The 'Error' box shows an "ORA-01403: no data
> found".
>
> This doesn't happen all the time but more often than not. I can usually
> quit the form, re-enter and perform exactly the same insert or update
> successfully.
>
> Does anyone have any ideas what may be causing this?
>
> Thanks...
>
> Neil W. Garside (Brisbane, Australia)
Received on Thu Jan 27 2000 - 15:07:59 CET