Re: Forms 3.0 and Oracle 8i (8.1.7) ( Invalid Rowid)

Frank <fvanbortel_at_netscape.net> wrote in message news:<3EAA9CB4.2010600_at_netscape.net>...
> Moron wrote:
> > Hi,
> >
> > as we are migrating our database onto Oracle 8i, we are expieriencing
> > some
> > Rowid problems.
> >
> > We already applied the "unsupported" patch which allows forms3 to
> > connect on 8i databases.
>
> You already know it's a no-no situation; why pursue the impossible?
> What's the reason for upgrading to 8i? Desupport of your current
> version 6?
>
> >
> >>After insert or update of a record, we get an error :FRM-40501 / ORA-01410: invalid Rowid as soon as the record has been commited in the DB if we try to modify it again.
> >>PL SQL: any statement like " insert into table A() select () from table B where Rowid = :My_block.rowid" raises exactly the same SQL error.
> >
> >
> > Has somebody got the same troubles ?
>
> Yes - everyone trying to run V6 clients against V8i databases.
> Forms V3 was desupported in the V7.1 days, somewhere last century.
> Why not upgrade to a later version? Dev6i still supports the
> c/s model...
>
> > Is there any other patch or workaroud ?
> >
> No patch. Workaround: you do all conversions from rowid to
> primary key columns, or as suggested: redefine used rowid
> columns to varchars.
> Doubt if that works, though, as forms uses rowid internally.
> That means you will get these errors on forms/blocks you never
> defined a rowid field in.
> Upgrade is the only w/a.

Hoops ,

sorry, in fact the environment wasn't correctly configured and we were using
an unpatched version of forms 3. Now we are running the patched version it works fine as far as we have tested. The patch # is 435593 but not very easy
to get from Oracle Support as it is not supported.

Tanks for sharing help. Received on Tue Apr 29 2003 - 08:01:41 CEST