Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Limit on the number of records to read through a cursor?
fareeeda wrote:
> Hi,
>
> Is there any parameter that defines the limit on the number of records
> to be read through a cursor (using OCI APIs)?
> We have had a problem a couple of times when after a certain limit,
> oracle starts throwing following error: ORA-1455 (saying something
> about integer overflow).
> Note that this happens only if number of records read exceeds a
> certain limit (was different each time).
>
> Is this related to certain oracle versions (we are using different
> flavors of Oracle 9i)? And if there is any such parameter, does it
> have any defaults?
>
> Thanks and Regards
> Fareeda
Do you probably return ROWNUM and convert it into an inappropriate host type? Or maybe you are reading a column whose value grows larger the more records you retrieve.
Just some ideas...
robert Received on Wed Jul 13 2005 - 06:37:43 CDT
![]() |
![]() |