Converting ROWID in OCI 8
Date: Tue, 20 Jul 1999 16:27:36 GMT
Message-ID: <7n2816$oi$1_at_nnrp1.deja.com>
Hello,
Has anyone converted the 10-byte extended rowid from the binary form to the char array of 18 bytes without using chartorowid() in the select statement? That is, doing this:
"select rowid from dual" and converting, not this:
"select rowid, chartorowid(rowid) from dual".
Chap 4 of 8.1.5 App Dev Guide - Fundamentals defines the C structure for the binary rowid. I can OCIDefineByPos() the pointer to this struct instead of the OCIRowid struct (which I cannot sizeof) to retrieve the binary form of the rowid. To verify that this is a valid rowid, I then OCIBindByPos() the rowid into a delete statement and the record does delete. I have the base64 chart available and any attempt to convert does not produce the same result as the chartorowid() PL/SQL function.
Any help?
Thanks,
Boris Gelfand
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Jul 20 1999 - 18:27:36 CEST