Oracle-Error ora-1403 on insert or update in forms 6.0

From: Hans Quick <quick_at_numrich.de>
Date: Wed, 13 Sep 2000 17:39:58 +0200
Message-ID: <39BF9FCE.44126888_at_numrich.de>


Hi,

[Quoted] we have the following serious problem in a few forms-modules in our application:

On insert or update of the table TITEL we receive the Error-Message: Unable to update record. The "display_error"-Command shows the following message:
ORA-01403: no data found. The SQL-Statement in error is empty, or sometimes filled with nasty characters.
All other modules works quite fine. All these modules worked over years in forms 4.5.
After upgrade them to Version 6.0 of forms this strange behaviour happens. The block for this table has no special triggers. The only difference to other tables in this application, is that this table has about 165 columns. The other tables are much smaller.

If we mark some of the fields in this block as NON-basetable-Items the Insert or Update succeeds.

The insert and update also succeeds if we run the module in debug-mode.

We use forms runtime with the newest patch (version 6.0.5.35.3) and the database "Oracle7 Server Release 7.3.2.2.0".

Hope that some one can help us.

Thanks in advance
Hans Quick Received on Wed Sep 13 2000 - 17:39:58 CEST

Original text of this message