At 10:47 AM 10/02/2004 +0000, you wrote:

>Hello All,
>I've stored procedure which takes in varchar as a parameter. This string
>has to be appended to give another update statement to form a query such
>as "update table1 set column1='<value1>' where column2 in ()".
>
>Can anyone give me idea how big string can I pass to the stored procedure?
>For eg. In Mysql, without some option enabled one can't pass a string
>arguement more than 1024 bytes.
>Is there any such limit for Firebird?

Yes, but it's 32765 bytes. :-) Just watch it if you are using unicode -
it's BYTES not characters. 32765/3 gives you a limit of 10921 unicode
characters.
/hb