Re^2: SQL queries using dynamic array

just remember that a SQL statement can contain at most 4000 chars.

Which database has that limitation?

I've googled a bit, and I think that you have that statement mixed up with '(some char column type(s)) can be at most 4000 characters', which would mean that each bind variable could be at most that length.

Comment on Re^2: SQL queries using dynamic array

Replies are listed 'Best First'.
Re^3: SQL queries using dynamic array by pg (Canon) on Aug 04, 2005 at 04:48 UTC
The limitation for Microsoft SQL 2000 is 4000 characters. that's unicode, and we are talking about 8000 octets. I could not remember the exact length limitation for Oracle, but my pression is that it is 3000+ characters. (The Oracle I use is a bit old, version 8.1.7)	[reply]
Re^4: SQL queries using dynamic array by runrig (Abbot) on Aug 04, 2005 at 17:04 UTC
I guess I've been spoilt by Informix for too long (limit 32K). I did find some info on Oracle, which indicates the limit may be more than 3K, even for 8.x, though there could be some limit of the tools used to access the database.	[reply]