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

[Quoted] I have a strange feeling the combination of the newest patch and an old version of Oracle, which was desupported in 1998 (and Oracle 7 is going to be desupported completely on December 31) is the likely culprit. I'm almost sure 6.0 was released after 7.3.2 has been desupported.

Regards,

Sybrand Bakker, Oracle DBA

"Hans Quick" <quick_at_numrich.de> wrote in message news:39BF9FCE.44126888_at_numrich.de...
> Hi,
>
> 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 - 19:09:27 CEST