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

From: Nico <nico.vandenb_at_easynet.be>
Date: Sun, 27 Apr 2003 09:54:41 +0200
Message-ID: <o33navsoaia0lv38r6ti26hbbe68321gec@4ax.com>

don't know if this is possible in 3.0 but in forms version 4.5 you could specify to use the primary key instead of the rowid (it's a block property)

regards

Nico

On 24 Apr 2003 22:52:21 -0700, moron.jean-luc_at_rcc.ch (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.
>> 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 ?
>Is there any other patch or workaroud ?
>
>Thans for your help
>
>Regards
>
>Jean-Luc
Received on Sun Apr 27 2003 - 02:54:41 CDT