Re: rowid of inserted row

In article <3pm47j$j3q_at_cantaloupe.srv.cs.cmu.edu>, Mark Hjelm <hjelm+_at_cs.cmu.edu> wrote:
>
>I may be overlooking something obvious, but is there a direct way to
>obtain the rowid of a row I've just inserted into a table? I can
>think of several indirect ways, but I'd rather not have that much
>overhead. I'm using ProC, but I'd gladly drop lower, if it would
>help.
>

I may have an answer for you. Please refer to the following definition of a cda_def from $ORACLE_HOME/rdbms/demo/ocidfn.h

/* the real CDA, padded to 64 bytes in size */ struct cda_def {

    sb2          v2_rc;                             /* V2 return code */
    ub2          ft;                             /* SQL function type */
    ub4          rpc;                         /* rows processed count */
    ub2          peo;                           /* parse error offset */
    ub1          fc;                             /* OCI function code */
    ub1          rcs1;                                 /* filler area */
    ub2          rc;                                /* V7 return code */
    ub1          wrn;                                /* warning flags */
    ub1          rcs2;                                    /* reserved */
    sword        rcs3;                                    /* reserved */
    struct {                                       /* rowid structure */
        struct {
           ub4    rcs4;
           ub2    rcs5;
           ub1    rcs6;
        } rd;
        ub4    rcs7;
        ub2    rcs8;
    } rid;
    sword        ose;                          /* OSD dependent error */
    dvoid        *rcsp;                   /* pointer to reserved area */
    ub1          rcs9[64 - sizeof (struct cda_head)]; /* filler to 64 */

The rowid structure "rid" may contain the rowid you are looking for in some combination of the fields rcs[4...8]. You are looking for three numbers, a block, a row, and a file. Frankly, I'm not sure why there are 5 variables but I'm pretty sure the answer lies within a combination of them. I used to work at Oracle in the RDBMS group and we put that hack in back in version 6 to help us win a benchmark by saving the very same effort you are trying to save.

Hope I'm right,
SCott.
smartin_at_turnstone.com
415-851-9576

>Oracle 7.1.3, SunOS 4.1.3
>
>Mark Hjelm
>mwh_at_formtek.com
>hjelm_at_cs.cmu.edu
Received on Sun May 21 1995 - 00:00:00 CEST