At 08:17 AM 21-11-01 +0000, you wrote:

>Hi,
>
>(FB1.0.0RC1/Win2000)
>I have a SP with a string as parameter:
>
> create procedure my_sp ( p_value varchar ( 4096 ))
> as
> begin
> /* do something */
> end
>
>When giving an concatenated string to this SP as parameter:
>
> execute procedure my_sp( 'string a' || 'string b')
>
>I get the following error message:
>ISC ERROR CODE:335544569
>
>ISC ERROR MESSAGE:
>Dynamic SQL Error
>SQL error code = -104
>Token unknown - line 1, char 60
>||
>
>Is it really forbidden to use || when calling a SP?

Yes, you cannot pass an expression as a parameter value, only a constant.

Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________