> >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.

Just a side note.

One will hit a limit of Firebird 1.0 when using a stored procedure
with huge parameters in another procedure or trigger several times.

For example a stored procedure that encapsulates an INSERT INTO a
log table, and the stored procedure is called in a trigger several
times, one won't be able to compile the trigger. If I move back
to normal INSERT INTO statements, then the trigger get compiled
but you might hit another limit, namely the maximal length of
a single SQL statement when creating the trigger. ;-)

Don't know if that limitation in Firebird 1.5 still exists.


Thomas