Re: retrieving objects usign OCI

> Actually this code is written for Oracle8, which I
> believe doesnot support user-defined object retrieval
> using OCI. A casual glance over the code shows that
> there are no OCI calls like OCIDefineObject,
> OCIObjectNew etc. which may be needed to define place
> holders for return values on a statement fetch.

I believe that oci8 supports these calls (I've never used them, but they are in the 8i oci programmers ref guide). I can't give you a reference I can personally vouch for, but these hits off google looked good.

http://www.ms.mff.cuni.cz/~kopecky/ora8doc/appdev.804/a58234/app_exam.htm
http://uisnt1.humboldt.edu/otn/library/product/tools/pg2k/info/oci_tips.pdf
http://www.math.ut.ee/~askot/oradox/orasupp/coderep/cat00009/smpl0069.htm
http://www.math.ut.ee/~askot/oradox/orasupp/coderep/cat00009/smpl0029.htm

Plus of course the Oracle OCI Programmers reference whihc you can get off technet.

As a note Oracle::OCI supports those calls, but I don't see any examples of how it's used besides the ones here:
http://www.cpan.org/modules/by-authors/Tim_Bunce/OCI_Talk1_200106.zip

If whomever mentioned examples of this in work could forward some links for it, I'd be appreciative.

Best of luck,

George

>
> I'd appreciate any further comments.
>
> Thanks and regards,
> Siddharth.
>
> --- George Schlossnagle <george_at_omniti.com> wrote:
>> No offense, but you couldn't have looked too hard.
>> 30 seconds on CPAN
>> led me to:
>>
>>
> http://www.cpan.org/modules/by-module/Oraperl/TIMB/Oracle-
>> OCI-0.06.tar.gz,
>> a tar ball with the latest veriosn of the perl
>> module mentioned. That
>> having been said, I don't believe this module has
>> any useful examples
>> for you. I would recommend looking at libsqlora
>> http://www.poitschke.de/libsqlora8/ a wrapper
>> library for oci. It will
>> either do what you want (if you want to just use
>> that instead of oci),
>> or looking at it's implementation should give you
>> all you need to know
>> about using oci.
>>
>> George
>>
>> // George Schlossnagle
>> // www.pythian.com -- schlossnagle_at_pythian.com --
>> 877-PYTHIAN
>> // Smarter than adding another team member, Pythian
>> has new services
>> // for supplementing DBAs: get our help with
>> monitoring, 24x7 on-call,
>> // daily verifications, storage management,
>> performance and more.
>>
>>
>>
>
> __________________________________________________
> Do You Yahoo!?
> Send your FREE holiday greetings online!
> http://greetings.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: siddharth aggarwal
> INET: siddharthaggarwal_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: George Schlossnagle
  INET: schlossnagle_at_pythian.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).