Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Database Application Development
Oracle Call Interface (OCI)
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Jan 21, 2013 8:12 AM by
explicit cursor fetches only fewer records pro*c
Jan 21, 2013 8:12 AM
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.
This content has been marked as final.
Show 0 replies