Hi - Suppose one's passing back a rowid from a stored procedure to C/C ++ (using say OTL or equivalent). What is the corresponding C++ type? Right now my C/C++ type is a 19 byte string:
create or replace procedure ....(rw_id OUT rowid) begin insert into sseoms_order values(...) returning rowid into rw_id; end The returning row id is being copied into a char[19]. As an aside I tested code that does searches with unique primary keys vs. the same tables without any indexes and the searches replaced with rowid such as: update ... where rowid=id; Unexpectedly the rowid approach under performs the unique primary index. I'm wondering if I'm wasting time passing large 19 byte ids betwee the app and the server and/or doing implicit chartorowid()/ rowidtochar() conversions. Shane --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en -~----------~----~----~----~------~----~------~--~---
