🚀 go-pugleaf

Hi I want ot write my first stored procedure with Firebird 1.5.
But it is very hard for me. It don�t work.
I run always in trouble. Where�s the problem??

Thanks
Dierk


CREATE PROCEDURE INSUPD_MESSWERT(
    iStation SMALLINT,
    iMesspunkt SMALLINT, iZeitpunkt TIMESTAMP,
    iStatus SMALLINT,
    iMesswert DOUBLE PRECISION )
AS
BEGIN
  INSERT INTO Messwerte(Station, Messpunkt, Zeitpunkt, Status, Messwert)
  VALUES (:iStation, :iMesspunkt, :iZeitpunkt, :iStatus, :iMesswert);

  /*Doppelter Prim�rindex */
  WHEN SQLCODE -803 do

    UPDATE Messwerte SET
      Station = :iStation,
      Messpunkt = :iMesspunkt,
      Zeitpunkt = :iZeitpunkt,
      Status = :iStatus,
      Messwert = :iMesswert
    WHERE (Station=:iStation) and (Messpunkt=:iMesspunkt) and
(Zeitpunkt=:iZeitpunkt)
  END

END



////////////////////////////////////////////////////////////
Statement #1:
Dynamic SQL Error
SQL error code = -104
Unexpected end of command

Statement #2:
Dynamic SQL Error
SQL error code = -104
Token unknown - line 4, char 3
WHEN

////////////////////////////////////////////////////////////