Home » Developer & Programmer » Precompilers, OCI & OCCI » Upper range of fetch
Upper range of fetch [message #93835] Fri, 14 February 2003 02:21 Go to next message
Varadarajan S
Messages: 2
Registered: February 2003
Junior Member
HI,what is max number of rows that can be bulk fetched into a array in oci8
Re: Upper range of fetch [message #93839 is a reply to message #93835] Fri, 14 February 2003 20:56 Go to previous messageGo to next message
Srinivas
Messages: 138
Registered: June 2000
Senior Member
If you are talking about oracle/cobol program, it will be just more than 32000.

bye

srinivas
Re: Upper range of fetch [message #93842 is a reply to message #93835] Mon, 17 February 2003 01:38 Go to previous messageGo to next message
Varadarajan S
Messages: 2
Registered: February 2003
Junior Member
HI,thanks for the info,but can u please tell me the upper limit for C/C++.
Re: Upper range of fetch [message #93880 is a reply to message #93835] Sun, 02 March 2003 10:11 Go to previous message
langda
Messages: 5
Registered: March 2003
Junior Member
There is no limit. Even in bulk fetch you do get the results in batches from the server .
Make sure you dont run out of memory allocating to the arrays of fetch . (This typically depends upon process maximum stack and heap space of the totral 4gb address space ). If you are on 64 bit platform ..i guess your hardware is the limit then ..
Previous Topic: SQLCURSOR variable and dynamic SQL
Next Topic: Segmentation Fault when i execute "exec sql connect"
Goto Forum:
  


Current Time: Thu Mar 28 07:04:28 CDT 2024