Selecting varray using python
aminabdu at paul.rutgers.edu
Wed Sep 5 21:03:07 CEST 2001
In the makefile for DCOracle threre is a setup for 8i also, so my
guess was DCOracle supports 8i. Select clauses where columns have
atomic values seem to be OK.
Anyhow I tried the whole thing again with DCOracle2. This time
again something strange happened:
1) I have a table "test2" with 2 columns "id" and "arrcol". Arrcol
is of type "arrtype" which is a varray of varchar.
2) This is what I inserted to the table test2:
insert into test2 values (1, arrtype('john','paul'));
3) Selecting from sqlplus returns:
select * from test2
1, ARRTYPE('john', 'paul')
4) Now using python I type
>>> db = DCOracle2.connect("...")
>>> c= db.cursor()
>>> c.execute("select * from test2")
[('ID', 'NUMBER', 22, 22, 38, 0, 1), ('ARRCOL', 'TYPE', 2000, 2000, 0, 0, 1)]
Segmentation fault (core dumped)
I was expecting a list to be returned. Anyone familiar with Varrays able
to help out?
"Maan M. Hamze" <mmhamze at pleiades.net> wrote in message news:<tpcbeh5irano9f at corp.supernews.com>...
> You lost me here. Are you sure that DCOracle works with Oracle 8i? I know
> that DCOracle2 does.
> "Amin Abdulghani" <aminabdu at paul.rutgers.edu> wrote in message
> news: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
More information about the Python-list