Re: retrieving objects usign OCI

2001-12-25 Thread siddharth aggarwal
Thanks George for the links. I went through the examples and have observed that in all the cases, a corresponding C structure is known for the user defined type at compile time and hence it has been hardcoded. This structure is then used to allocate memory in the OCIDefineByPos and OCIDefineObjec

Re: retrieving objects usign OCI

2001-12-25 Thread siddharth aggarwal
Thanks George for the links. I went through the examples and have observed that in all the cases, a corresponding C structure is known for the user defined type at compile time and hence it has been hardcoded. This structure is then used to allocate memory in the OCIDefineByPos and OCIDefineObjec

Re: retrieving objects usign OCI

2001-12-25 Thread George Schlossnagle
> 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

Re: retrieving objects usign OCI

2001-12-25 Thread siddharth aggarwal
Thanks george for the links and apologies for my relaxed attitude. I did check up the http://www.poitschke.de/libsqlora8/ site and went through the code. Unfortunately it seems that won't solve my purpose. Actually this code is written for Oracle8, which I believe doesnot support user-defined

Re: retrieving objects usign OCI

2001-12-24 Thread George Schlossnagle
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

Re: retrieving objects usign OCI

2001-12-24 Thread siddharth aggarwal
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 <[EMAIL PROTECTED]> wrote: > > > I am trying to retrieve objects from an ORACLE 8i > > database u

Re: retrieving objects usign OCI

2001-12-24 Thread Steven Lembark
> 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 O

retrieving objects usign OCI

2001-12-24 Thread siddharth aggarwal
Hi, 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. Sid. ---