Re: select rowid through dblink from oracle7 to 8

From: Madhu Bandireddy <nilu_at_erols.com>
Date: Thu, 25 Mar 1999 15:40:03 -0500
Message-ID: <36FA9F23.63C437C@erols.com>

Use the DBMS_ROWID package which is created by dbmsutil.sql which in turn is created by executing the catproc.sql script. This script creates

many stored procedured for manipulating ROWIDs.The DBMS_ROWID functions for migration are :

1) ROWID_TO_EXTENDED ( )  It converts 7 rowid format to 8.
2) ROWID_TO_RESTRICTED ( ) coverts 8 rowid format to 7.
3) ROWID_VERIFY ( ) tells u whether or not  oracle 7 rowid can be

converted to 8 using the first function.

Nilima

Daniel Tisserand wrote:

> We are trying to update a table by rowid through a dblink. The rowids
> are
> a different format in oracle8 than in 7. Is there a way to convert
> the
> rowid either statically or dynamically during processing?
>
> Daniel
Received on Thu Mar 25 1999 - 14:40:03 CST