Firebird: SP1 ruft SP2 auf (SP2 enthält For Select)

[mkinzler]

Versuch mal

SQL-Code:

CREATE PROCEDURE SP_GETBASECOSTCENTER2
RETURNS (
    THEPERSONALID INTEGER,
    THEPERSONALNAME VARCHAR(30),
    THEPERSONALFIRSTNAME VARCHAR(20),
    THECOSTCENTERID INTEGER,
    THECOSTCENTERNO VARCHAR(20),
    THECOSTCENTERNAME VARCHAR(100))
AS
begin
  for select 
      * 
  from 
      SP_GETBASECOSTCENTER1('Now')
  into
    :THEPERSONALID,:THEPERSONALNAME,:THEPERSONALFIRSTNAME,
    :THECOSTCENTERID,:THECOSTCENTERNO,:THECOSTCENTERNAME do
  begin
      suspend;
  end
end