Re: Oracle 8i RowID help

If you want specific help on Pro*C / OCI you could try the Metalink forums. If you want to use a volunteer newsgroup, a little patience is sometimes required.

Oracle 8i has a 'returning' clause that may be of use to you if you can declare and use a local bind variable for the rowid.

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases
Publishers:  Addison-Wesley

Reviews at: http://www.jlcomp.demon.co.uk/book_rev.html



bwiegan_at_axisdata.com wrote in message <95br7v$k2f$1_at_nnrp1.deja.com>...


>Since I have not gotten any repsonses, is there a better forum for my

>question? Or a different approach for accessing the the last record

>inserted (rather than by rowid)?

>

>Thanks, Barry

>

>In article <959uah$25i$1_at_nnrp1.deja.com>,

>  bwiegan_at_axisdata.com wrote:

>> We are trying to migrate from Oracle 7.3.4 to 8.1.7 running under

 HPUX,


>> and have run into a problem. We have the following oci code which

 works


>> for 7.3.4, but obviously will not for 8i:

>>

>> void copy_rowid_from_cursor(char *rowidPtr)

>> {

>>   sprintf(rowidPtr, "%.8X.%.4X.%.4X",

>>   ora_cursor.csrrid.ridbrba,

>>       ora_cursor.csrrid.ridsqn,

>>       ora_cursor.csrrid.ridtid.tidpid);

>>   return;

>> }

>>

>> ora_cursor is a global csrdef cursor variable that gets set from a

>> previous insert. The new csrdef in 8i does not have these subelements

>> for the cssrid (rowid) definition. So is there anyway to generate

>> an equivalent rowid string in 8i that uses the new 18 character

>> alphanumeric representation? (I inherited this code, I didn't write

 it.


>> :-))

>>

>> Sent via Deja.com

>> http://www.deja.com/

>>

>

>

>Sent via Deja.com

>http://www.deja.com/