Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.python > #104035

Re: cx_Oracle + array parameter

From sandrof66 <sandrof66@hotmail.com>
Subject Re: cx_Oracle + array parameter
Newsgroups comp.lang.python
References <9bdf8184-aa7d-42d5-8288-dea1b4f50fda@d61g2000hsa.googlegroups.com>
Message-ID <24SdnUUFFZr4F0TLnZ2dnUU7-TvNnZ2d@giganews.com> (permalink)
Date 2016-03-04 07:15 -0600

Show all headers | View raw


I did your solution. I created a varray like this: TYPE LIST_IDS IS TABLE OF INT INDEX BY BINARY_INTEGER, but when I try to use in a sql statement SELECT appears an oracle error cannot access row in nested table. I use oracle 11g and I read that you can use a varray declare in plsql to sql statement.

Back to comp.lang.python | Previous | Next | Find similar | Unroll thread


Thread

Re: cx_Oracle + array parameter sandrof66 <sandrof66@hotmail.com> - 2016-03-04 07:15 -0600

csiph-web