0 Replies Latest reply: Jan 21, 2013 8:12 AM by 986140 RSS

    explicit cursor fetches only fewer records pro*c

    986140
      hi there,



      i have a pro*c application where i am opening a cursor and fetching data from it.



      the select statement used for this cursor is giving me a output of 2000 records and each having some 2Kb of data, if i do it manually from sqlplus.



      but while fetching from the explicitly created cursor it is able to fetch only upto 500-600 records.



      do i need to change any configurations ?



      the ESQLs are..



      EXEC SQL PREPARE S1 FROM :sqlQuery;



      EXEC SQL DECLARE C1 CURSOR FOR S1;



      EXEC SQL OPEN C1;



      EXEC SQL DESCRIBE SELECT LIST FOR S1 INTO seldp ( SQLDA* initialized all parameters)



      do{

      EXEC SQL FETCH C1 USING DESCRIPTOR seldp;



      counter++

      }while(sqlca.sqlcode!=0)



      EXEC SQL CLOSE C1;



      and the counter reaches upto 500-600 only.



      please help me regarding this.