I suspect it's caused by the RDBMS Service property setting. Go to the
command center, click on RDBMS Service, click on Worker Properties tab,
then increase the Maximum Records to Retrieve property to something
higher than 5000.
Aileen Jen
Senior Consultant
EnterpriseWorks
(713) 934-0200
[EMAIL PROTECTED] wrote:
>
> We are trying to retrieve upwards of a million rows from an Oracle 7.3.3 DB via
a call to CSpDataObject.executeImmediate("ds", "query", 999999). Specifying
5000
or less for the max rows parameter has the anticipated effect, however
increasing
the value beyond 5000 simply returns the first 5000 rows. Anyone know any
workarounds?
_________________________________________________________________________
For help in using, subscribing, and unsubscribing to the discussion
forums, please go to: http://www.netdynamics.com/support/visitdevfor.html
For dire need help, email: [EMAIL PROTECTED]
