Re: retrieving objects usign OCI

From: siddharth aggarwal <siddharthaggarwal_at_yahoo.com>
Date: Tue, 25 Dec 2001 21:24:27 -0800
Message-ID: <F001.003E29DF.20011225210518@fatcity.com>

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 OCIDefineObject calls so as to receive a row of data during the OCIStmtFetch call.

However my problem is that I donot know the structure of the type at compile time. I am making a general purpose data access mechanism and hence cannot hard-code any C structures in my code. I would rather know the structure of the object at runtime and then fetch the object.

Looking forward to some more help in this regard. Regards,
Siddharth.

• George Schlossnagle <schlossnagle_at_pythian.com> wrote:
  > > 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.
  > >
  

  ---

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

Received on Tue Dec 25 2001 - 23:24:27 CST