Oracle-Error ora-1403 on insert or update in forms 6.0
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