INSERT ... RETURNING question

[T UA]

What am I missing? Thanks in advance for any help!

Message: isc_dsql_execute2 failed

SQL Message : -104

Invalid token

Engine Code    : 335544351

Engine Message :

unsuccessful metadata update

CREATE PROCEDURE INSERT_PAYITEMS failed

Dynamic SQL Error

SQL error code = -104

Unexpected end of command - line 0, column 0

/*

CREATE TABLE PAYITEMS (

  ID           ID GENERATED ALWAYS AS IDENTITY PRIMARY KEY,

  STATECODE    STATECODE,

  ITEMNUMBER   MEDIUMTEXT NOT NULL,

  DESCRIPTION  LONGTEXT,

  UNITS        UNITS,

  ALTUNITS     UNITS

) ;

*/

SET TERM ^ ;

CREATE PROCEDURE INSERT_PAYITEMS (

  STATECODE   STATECODE,

  ITEMCODE    MEDIUMTEXT,

  DESCRIPTION LONGTEXT,

  UNITS       UNITS)

RETURNS (PAYITEM_ID ID)

 

AS 

BEGIN

  INSERT INTO PAYITEMS (

    STATECODE,

    ITEMCODE,

    DESCRIPTION,

    UNITS)

  VALUES (

    :STATECODE,

    :ITEMCODE,

    :DESCRIPTION,

    :UNITS);

  RETURNING ID;

END^

SET TERM ; ^

[Vlad Marginean]

CREATE PROCEDURE INSERT_PAYITEMS (

  STATECODE   STATECODE,

  ITEMCODE    MEDIUMTEXT,

  DESCRIPTION LONGTEXT,

  UNITS       UNITS)

RETURNS (PAYITEM_ID ID)

AS

 

BEGIN

 

  INSERT INTO PAYITEMS (

    STATECODE,

    ITEMCODE,

    DESCRIPTION,

    UNITS)

  VALUES (

    :STATECODE,

    :ITEMCODE,

    :DESCRIPTION,

    :UNITS)

  RETURNING ID INTO :PAYITEM_ID;  -- here

 

  SUSPEND; -- here

END^

 

SET TERM ; ^

--
You received this message because you are subscribed to the Google Groups "firebird-support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-suppo...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-support/3a65a3a3-177d-4d95-9dd8-3e31050b63fan%40googlegroups.com.

[T UA]

thanks - much appreciated!