re: C++ equivalent type to Oracle's rowid.

What is the C/C++ equivalent to Oracle's rowid?

Currently I am using OTL 4.0 and passing/returning rowids to Oracle stored procedures e.g.:

insert into ... values( .. ) returning rowid into rw_id; # returning id
update ... set .. where rowid=ord_id; # passing in id

Right now my C/C++ type is char[19].

As aside I was benchmarking a design which uses a unique primary index to perform the updates like this:

  update ... ser where order_id=ord_id and order_date=ord_date;

vs. a design in which there were NO/ZERO indexes and the update was done like:

  update ... set .. where rowid=id;

Unexpectedly the indexed version generally out performs the rowid approach. I was thinking that passing around 19 byte rowids and/or implicit chartorowid()/rowidtochar() were slowing down the rowid version.

Shane Received on Mon Mar 23 2009 - 23:00:16 CDT