Re: retrieving objects usign OCI

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.

On Tuesday, December 25, 2001, at 01:55 AM, siddharth aggarwal wrote:

Hi,

I checked out the cpan website but couldn't find any such OCI examples that you have mentioned. I would really appreciate if you could send the appropriate link.

Thanks,
Sid

• Steven Lembark <lembark_at_wrkhors.com> wrote: I am trying to retrieve objects from an ORACLE 8i database using OCI. I have attached some code that I wrote for the same but it fails at the OCIStmtFetch call with the error ORA-00932 inconsistent datatypes. Has anyone worked on such an issue before? Thanks in advance.

Check out Oracle::OCI on CPAN. It is a Perl interface
to the OCI lib's by the same gent who wrote DBI and DBD::Oracle. It has plenty of examples -- both from the internal code using OCI and the Perly interface.

--
Steven Lembark                               2930 W.
Palmer
Workhorse Computing                       Chicago,
IL 60647
+1 800
762 1582
-- 
Please see the official ORACLE-L FAQ:
http://www.orafaq.com
-- 
Author: Steven Lembark
INET: lembark_at_wrkhors.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).


__________________________________________________
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).