in reply to Re^2: SQL queries using dynamic array
in thread SQL queries using dynamic array

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)

Replies are listed 'Best First'.
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]

In Section Seekers of Perl Wisdom