Size limit for a single SQL statment in Oracle is quite large - either 32
or 64 k I think.
There's no limit on using _ as far as I know. You could always store the
query in a file and use replace() to substitute parameter values for
placeholder text.

Tim

--
Tim Williams
Palo Alto, CA


"cesw" wrote in message
...

We are running VB 6.0 using ADO to connect to an Oracle backend.
It seems continuations are limited to about 24 lines, so my rather
large query is strung out hundreds of bytes lengthwise.
I'm getting an Oracle -923, from keyword not found where expected
error.
The query runs in Toad when I take out the " " & _ continuation
characters so I think it's ok.
Is there a byte restriction on the length of the ResultSet.open
command, or a line length at which the query may be getting truncated?

Thx


--
cesw
------------------------------------------------------------------------
cesw's Profile:
http://www.excelforum.com/member.php...o&userid=27117
View this thread: http://www.excelforum.com/showthread...hreadid=466758