Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Obtaining the rowid...

Obtaining the rowid...

From: Aníbal Cáceres Hernando <anibal_at_transtools.com>
Date: Tue, 27 Jul 1999 19:13:23 +0200
Message-ID: <379DE8B3.1F3C8550@transtools.com>

    Hello,

    I'm managing Oracle 8 with the Oracle Call Interface (OCI), but using the old functions of this API, because I'm mantainig a program designed for Oracle 7. I want to get the character values representing the ROWID when I execute an INSERT statement to add a row. In Oracle 7 and earlier releases these values were as follows:

    block.row.file (being block the data block of the data file containing the row, row the row in the data block, and file the database dile containing the row).

    and this values could be got directly from some of the fields of the cda_def->rid structure. This has changed in Oracle 8, and the rowid isn't now represented like that. So my question is: how can I construct the character representation of the rowid in Oracle 8 when I insert a new row?, can I obtain it from the cda_def structure, as in Oracle 7?, must I use some other way?

    Thanks a lot for your attention and time.

    Kind regards,

    Anibal.

--
Anibal Caceres Hernando
TransTOOLs, S.A.
Madrid - SPAIN Received on Tue Jul 27 1999 - 12:13:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US