Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: functions with more than one result-rows
Check your Oracle docs concerning REF CURSORS...
That should get you going..
"Andreas Neef" <aneef_at_oasdatic.de> wrote:
>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 - 11:14:44 CST