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

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.

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.

-- 
Regards, Frank van Bortel