This discussion is archived
0 Replies Latest reply: Jan 21, 2013 6:12 AM by 986140 RSS

explicit cursor fetches only fewer records pro*c

986140 Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points