Have you got a bind_array in your code ?
There is an example on my web-site that may help.
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
eastking_at_my-deja.com wrote in message <8re5ub$v7q$1_at_nnrp1.deja.com>...
>hello,every one here.
>
>I am using Oracle 8. When I fetch data by array , I meet a problem as
>following .Please help me.
>
>
> curSelect integer;
> CodeArray1 dbms_sql.Varchar2_table;
> CodeArray2 dbms_sql.Varchar2_table;
> nCount integer;@@
> dbms_sql.parse(curSelect,
> 'select
> ...
> ...
> from ...',
> dbms_sql.v7);
> dbms_sql.define_array(curSelect,1,CodeArray1,10,indx);
> dbms_sql.define_array(curSelect,2,CodeArray2,10,indx);
> ...
> ...;
> execute_select = dbms_sql.fetch_rows(curSelect);
> loop
> nCount := dbms_sql.fetch_rows(curSelect);
> dbms_sql.column_value(curSelect,1,CodeArray1);
> dbms_sql.column_value(curSelect,2,CodeArray2);
> ...
> ...;
> exit when nCount != 10;
> end loop;
>
>
>When I use CodeArray1 and CodeArray2, I found that never did the data
>in CodeArray1 or CodeArray2 be overriden by next fetch.It just increase
>it's indx one by one. Because I have almost 200 thousands records in a
>table, it seemed to be a problem with memory. How can I solve it.
>Thanks in advance.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Sat Oct 07 2000 - 08:00:11 CDT
