Re: Max length of SQL statement in Oracle7???

In article <4tk1d2$j7j_at_mtinsc01-mgt.ops.worldnet.att.net>, michael.n.gassner_at_ac.com (Michael N. Gassner) writes:

> Does anyone know the maximum length of a SQL statement that Oracle7
> can handle? I am writing a VB4 app that has a couple of free-form
> text fields that are capable of being 500 characters each -> resulting
> in a SQL statement that could reach 1500 characters. Will Oracle be
> able to handle this.

hi michael,

i think Oracle's limit is 64K characters. we have a VB3 app that generates dynamic SQL based on very many conditions. there is actually no upper limit on what the user could enter for conditions so i decided to run a test for very large SQL statements and found that VB barfed somewhere around 22000 characters with an out-of-string-space error. i haven't tested VB4 behavior but i'd be mighty surprised if it wasn't at least as good.

HTH                      david