Re: Limit on the number of records to read through a cursor?

From: Robert Klemme <bob.news_at_gmx.net>
Date: Wed, 13 Jul 2005 13:37:43 +0200
Message-ID: <3jkcocFqbsopU1@individual.net>

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