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 state
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 state
On 3 Gru, 19:07, Ian Clark <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> > Hello,
>
> > I'm trying to pass array as an argument into PL/SQL procedure.
> > According to cursor manual (http://cx-oracle.sourceforge.net/html/
> > cursorobj.html) arrayvar() should be use to do it. I've created
On 3 Gru, 19:07, Ian Clark <[EMAIL PROTECTED]> wrote:
> [EMAIL PROTECTED] wrote:
> > Hello,
>
> > I'm trying to pass array as an argument into PL/SQL procedure.
> > According to cursor manual (http://cx-oracle.sourceforge.net/html/
> > cursorobj.html) arrayvar() should be use to do it. I've created
[EMAIL PROTECTED] wrote:
> Hello,
>
> I'm trying to pass array as an argument into PL/SQL procedure.
> According to cursor manual (http://cx-oracle.sourceforge.net/html/
> cursorobj.html) arrayvar() should be use to do it. I've created my
> array type in PL/SQL:
>
> CREATE OR REPLACE TYPE cx_arra
Hello,
I'm trying to pass array as an argument into PL/SQL procedure.
According to cursor manual (http://cx-oracle.sourceforge.net/html/
cursorobj.html) arrayvar() should be use to do it. I've created my
array type in PL/SQL:
CREATE OR REPLACE TYPE cx_array_string is table of varchar2(200);
and
