functions with more than one result-rows

From: Andreas Neef <aneef_at_oasdatic.de>
Date: Wed, 29 Jan 2003 17:40:14 +0100
Message-ID: <b1908j$4kd$04$1@news.t-online.com>

Hi everybody!

I'm a newbi in Oracle. From other sql-servers I know, that multiple result-rows from a stored procedure are possible. Now I need these procedures in Oracle 8. How may I realize them?

Example from interbase:

CREATE PROCEDURE SP_ADRESSE_DRUCKEN
RETURNS ( ..... )
AS
DECLARE VARIABLE ANS_ID INTEGER;
begin
  for SELECT-STATEMENT-1 do
  begin
    ...
    suspend; /* SUSPEND returns values to caller */     for SELECT-STATEMENT-2do
    begin

      ...
      suspend; /* SUSPEND returns values to caller */

    end
  end
end

Thanks for your help.

Andreas, Germany. Received on Wed Jan 29 2003 - 10:40:14 CST