Re: Forms 6.0 and ORA-01403 errors

I also work with Developer 6. out DB version = 7.3.3.6.3 on mainframe and I haven't spotted this problem.

Angelo Cavallaro wrote in message <3890513F.1D0AEF1C_at_de.bosch.com>...
>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 Fri Jan 28 2000 - 09:22:49 CET