At 11:41 AM 19/10/2009, you wrote:

>Hi Helen
>
>Sorry If I am being a bit thick here :)
>
>I have my SP set up returning the result (defined in the returns) and
>returned after calling SUSPEND;
>
>On the client side My SQL was
>
>EXECUTE PROCEDURE pr_App_NewEntityAddress(:a, :b, :c, :d) RETURNING a
>
>I have tried changing it to
>
>EXECUTE PROCEDURE pr_App_NewEntityAddress(:a, :b, :c, :d)
>RETURNING_VALUES(a)
>and
>EXECUTE PROCEDURE pr_App_NewEntityAddress(:a, :b, :c, :d)
>RETURNING_VALUES(:a)
>and
>EXECUTE PROCEDURE pr_App_NewEntityAddress(:a, :b, :c, :d)
>RETURNING_VALUES :a
>and
>EXECUTE PROCEDURE pr_App_NewEntityAddress(:a, :b, :c, :d)
>RETURNING_VALUES a
>
>in all cases I get errors. The first to give me 'token unknown
>RETURNING_VALUES' and the later give me 'token unknown ?'
>
>What should me client side SQL be?

Just
EXECUTE PROCEDURE pr_App_NewEntityAddress(:a, :b, :c, :d)

RETURNING_VALUES and RETURNS are PSQL (a.k.a. Stored procedure and trigger language). They are not available to DSQL.

RETURNING is a specialised keyword implemented Fb 2 for ODS 11 that can return the values that were inserted by an INSERT statement.

Helen