German,

> does any body know how to perform string concatenation at a stored
> procedure ?

Use the double pipe symbol || .

For example:

SELECT MYVARCHAR1 || MYVARCHAR2 FROM MYTABLE;

Be aware that the concatenated string will be NULL, if one these
arguments is NULL.

HTH,
Thomas.