Re: ROWID problems with OCI 7 app and Oracle 8 server

> Oracle Support says that what we're trying to do is not possible! I
 find
> that pretty hard to believe.
>
> Does anyone have an OCI version 7 application that must construct the
> ROWID for a newly inserted row against an Oracle 8 database server? can
> you please help us?

The format has changed, but also the SIZE, its now 10 bytes instead of 6, so if in a v7 application you have a type rowid, it wants or expects 6 bytes, while in v8 it will want 10 bytes.

you have restricted rowid format, (the 6 bytes)in o8 which is still used internally but only when we talk about indexentries for nonpartitioned tables and local indexes. The reason for this change was to allow for more datafiles, we now have relative dbas, instead of the absoluut we had in v7.

so applications that used rowids, (why would you want to use an internal format to base an application on tho.) must use the dbmsrowid packages to convert, or its trouble.

Same goes for OID in Oracle 8, people that use OID are bound to get into trouble because the format can change (will). It is never good to use internal basic structures... So I think what they told you is correct. sorry...

cheers
wim Received on Wed Jan 14 1998 - 00:00:00 CST