fetching objects usign OCI

[email protected] ("Siddharth Aggarwal") Thu, 20 Dec 2001 17:13:42 +0530
Newsgroups perl.dbi.oracle-oci
Organization Persistent Systems Pvt. Ltd.
Message-ID <[email protected]>
------=_NextPart_000_0029_01C18979.ACE98DC0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,

I am working on an oracle8i data access layer using OCI. I am trying to =
implement the "select" query on user defined types (i.e. objects).
My understanding so far is that we need to define a C data structure =
using OTT and then make the OCIDefineByPos,.=20
OCIDescribeAny,OCIObjectPin and OCIDefineObject calls. i.e. we need =
prior information about the structure of the object we want to fetch and =
then allocate memory for it.

However I want to make a generic access mechanism i.e. determine at =
runtime the structure of the object, allocate place holders and then =
parse the returned object to get the attributes (an attribute maybe =
another object).

I would really appreciate if somebody could provide some code samples.

Thanks,
Siddharth Aggarwal.



------=_NextPart_000_0029_01C18979.ACE98DC0--