OraFAQ Forum: Precompilers, OCI & OCCI

Home » Developer & Programmer » Precompilers, OCI & OCCI » Upper range of fetch

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Upper range of fetch [message #93835]

Fri, 14 February 2003 02:21

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

Report message to a moderator

Re: Upper range of fetch [message #93839 is a reply to message #93835]

Fri, 14 February 2003 20:56

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

Report message to a moderator

Re: Upper range of fetch [message #93842 is a reply to message #93835]

Mon, 17 February 2003 01:38

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++.

Report message to a moderator

Re: Upper range of fetch [message #93880 is a reply to message #93835]

Sun, 02 March 2003 10:11

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 ..

Report message to a moderator

Previous Topic:	SQLCURSOR variable and dynamic SQL
Next Topic:	Segmentation Fault when i execute "exec sql connect"

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 06:40:03 CST 2024