On Mar 24, 6:57 pm, Shane <[email protected]> wrote:
> 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 -- Hide quoted text -
>
> - Show quoted text -
There is not one as far as I know.
David Fitzjarrell
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
