Re: Q: Max length of dynamic SQL query

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1997/01/15
Message-ID: <5biiec$1t2@newton.pacific.net.sg>#1/1

Andreas Listl <listl_at_rto.dec.com> wrote:
>Hi Folks,
>
>can anyone tell me the max length of an dynamic SQL query in
>PRO*C?
>
>Please post in this newsgroup or send e-mail to my account.
>
>Thanks to every usefull answer,
>
> Andy.
>

Hi there,

Probably 2000 as VARCHAR datatype takes a maximum of 2000. Since dynamic query requires a bind variable, I think the max length should be 2000. In case if my view is wrong, please let me know.

Regards

N.Prabhakar Received on Wed Jan 15 1997 - 00:00:00 CST