At 19:30 Monday, 19.04.2004 +0000, Muthu Annamalai wrote:

>I wrote a stored procedure and it was working good, after a while I
>need to change three output parameters using computed by method, but
>I am getting error on computed by line.

use this syntax:
FULLDESCRIPTION = DESCRIPTION || ATTRIBUTE1 || ATTRIBUTE2;

> I am using IB Expert to
>write Stored Procedure. Below I produce my Stored Procedure. Apart
>from this computed by error, my stored procedure returns four rows
>when there is three rows in the table, I am not able to solve that
>also

and try it without the last "suspend" (you have written "suspend" two times).

HTH,
Markus