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?

Regards,
Fabrice
mailto:fabrice.aeschbacher@...