IDS Forum

Re: roblem with stored procedure after migration

Posted By: FABIAN HORN
Date: Wednesday, 2 December 2009, at 1:17 a.m.

In Response To: Re: roblem with stored procedure after migration (Art Kagel)

Thanks Art,
but it is only a mistake by creating this example procedure. In the "real" procedure is a parenthesis. Here is the corrected version:

CREATE PROCEDURE pi_stellen(
p_Kapitel SMALLINT,
p_ID SMALLINT ,
p_Begin DATETIME YEAR TO FRACTION(5) ,
p_Kurznotiz VARCHAR(100,30) ,
p_Langnotiz references byte ,
p_Stellentyp_id integer ,
p_Abgang INTEGER )

RETURNING INTEGER;

DEFINE GLOBAL gvsRepID char(4) DEFAULT NULL;
DEFINE HNr integer;
LET HNr = 0;

IF gvsRepId IS NULL THEN

RAISE EXCEPTION -746, 0, 'Replikations-ID fehlt';

ELSE

CALL pG_Sys_NrServer( p_S_Kap_Id) RETURNING HNr;

IF HNr > 0 THEN

INSERT INTO HH_Stellen

(Kapitel, ID, Begin, Kurznotiz, Langnotiz, Stellentyp_Id, Abgang )

VALUES

(p_Kapitel, p_ID, p_Begin, p_Kurznotiz, p_Langnotiz, p_Stellentyp_Id, p_Abgang);

END IF;
END IF;
RETURN HNr;

Messages In This Thread

• roblem with stored procedure after migration
  FABIAN HORN -- Tuesday, 1 December 2009, at 1:51 a.m.
  • Re: roblem with stored procedure after migration
    Art Kagel -- Tuesday, 1 December 2009, at 9:39 a.m.
    • Re: roblem with stored procedure after migration
      FABIAN HORN -- Wednesday, 2 December 2009, at 1:17 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.