I create procedure FOO like:

create procedure FOO(Text varchar(100))
returns
(result varchar(100))
as
begin
result=text;
suspend;
end !!

I test it with

select * from foo('a' || 'b')

and I get the expected value 'ab'.

Now I redefine procedure FOO like:

create procedure FOO(Text varchar(100))
returns
as
declare variable result varchar(100);
begin
result=text;
end !!

I test it with

execute procedure from foo('a' || 'b')

and I get the error message "token unknown ||".

This looks weird to me...

Peppe Polpo