Submitted by: @dyemanov

SFID: 437859#⁠
Submitted By: dimitr

I'm not 100% sure this is a bug, but IMHO this ability
should be supported.

The engine does not allow to pass an expression with
string concatenation to a SP. When I'm compiling a
procedure with a line like this one:

execute procedure p_do_something('a' || 'b');

I get an error:

Invalid token.
Dynamic SQL Error.
SQL error code = -104.
Token unknown - line 14, char 57.
||.

Of course, the following work fine:

declare variable the_var varchar(64);
...
the_var = 'a' || 'b';
execute procedure p_do_something(the_var);