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

Hi

as i know, 7.3.2 is not y2k working, wether with Forms 4.5 nor 6. You have to upgrade as least to 7.3.4 (or 7.3.4.5 may be)

STL, qits

Sybrand Bakker schrieb:

> 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 Thu Sep 14 2000 - 15:32:15 CEST