> 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 <[EMAIL PROTECTED]> 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 -- [EMAIL PROTECTED] -- >> 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).