Re: pro*c -- limits on size or complexity of cursor?

From: Peter Sylvester <peters_at_mitre.org>
Date: 2000/03/06
Message-ID: <38C419F1.8181C645@mitre.org>#1/1

I'm not aware of a length limitation.
I believe that Oracle limits you to 256 values in an "IN(...)" clause, whereas Informix imposes no limit.

Peter

chrisoc_at_ans.net wrote:
>
> Using Pro*C with 8.1.5 are there any maxima on
> how long (lots of ANDS ) or how complex (subqueries)
> a cursor can be?
>
> I am looking at one we need to port from a Informix/ESQLC
> and it's 3500 chars long.
>
> Chris O'Connor
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Mar 06 2000 - 00:00:00 CST