Forms 6.0 and ORA-01403 errors

From: Neil W. Garside <nwgarside_at_my-deja.com>
Date: Mon, 24 Jan 2000 03:15:38 GMT
Message-ID: <86gg4h$jo1$1_at_nnrp1.deja.com>



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?

[Quoted] Thanks...

Neil W. Garside (Brisbane, Australia)

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Jan 24 2000 - 04:15:38 CET

Original text of this message