Stored Procedure innerhalb anderer SP

[alex517]

Hi Hansa,

versuchs doch mal damit

SQL-Code:

CREATE PROCEDURE TESTPREISSP8 
RETURNS (
    ID INTEGER,
    NR INTEGER,
    BEZ CHAR(30),
    PREIS DECIMAL(15,2))
AS
begin 
  for 
    select A.ID, A.NR, A.BEZ, P.PREIS 
    from 
      ART A
      join ERMITTLE_ARTPREIS (A.ID, 5, '01.01.2006') P on (1=1)
    where (ID <= 111)
    into :ID,:NR,:BEZ, :PREIS
  do 
    suspend; 
end^

alex