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

From: amogh <amogh.r_at_gmail.com>
Date: Wed, 13 Jul 2005 20:04:36 +0530
Message-ID: <7S9Be.16$pB5.187@news.oracle.com>

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
>

The converted form of the specified expression might have been too large for the specified datatype. You can try defining a larger datatype!

Can you give more details, the kind of data you are fetching, the OCI buffers, etc ... ?

Amogh Received on Wed Jul 13 2005 - 09:34:36 CDT