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)
EXEC SQL FETCH C1 USING DESCRIPTOR seldp;
EXEC SQL CLOSE C1;
and the counter reaches upto 500-600 only.
please help me regarding this.