So for the record what is the C/C++ equiv type to rowid?
On Mar 24, 9:16 am, ddf <[email protected]> wrote:
> On Mar 23, 10:38 pm, Shane <[email protected]> wrote:
>
>
>
>
>
> > 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've hit the nail on the head with the implicit conversion issue.
> The primary key index doesn't suffer that fate and thus it's much
> faster than your implicit conversion approach.
>
> David Fitzjarrell- Hide quoted text -
>
> - Show quoted text -
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
