Selecting varray using python

From: Amin Abdulghani <aminabdu_at_paul.rutgers.edu>
Date: 4 Sep 2001 14:58:59 -0700
Message-ID: <f5b09a2f.0109041358.20f1290d_at_posting.google.com>


Hi,

I have recently installed DCOracle 1.3.2 to interface Oracle 8i with python. The problem I seem to be facing is trying to access a varray column using the interface. Does anyone have anyone have experience doing that? I am new to varrays so there is a possibility I am employing a totally wrong approach. Here is what I do:
1) There is a table test2 with 2 cols: id and arrcol (array of varchar)
2) curs.execute("select arrcol from test2") Traceback (most recent call last):
  File "<stdin>", line 1, in ?
  File "/export/home/amin/py-driver/DCOracle-1.3.2/DCOracle/ociCurs.py", line 299, in execute

    r = self._execute(params__, kw)
  File "/export/home/amin/py-driver/DCOracle-1.3.2/DCOracle/ociCurs.py", line 241, in _execute

    out=self._describe(self._ft)
  File "/export/home/amin/py-driver/DCOracle-1.3.2/DCOracle/ociCurs.py", line 196, in _describe

    raise error, (
oci.error: Invalid type code, 109, for column 1

Any pointers will be much appreciated.

Thanks..
Amin Received on Tue Sep 04 2001 - 23:58:59 CEST

Original text of this message