Re: stored procedure returning multiple rows
From: Peter <Peter.Slingerland_at_WKAP.nl>
Date: Thu, 31 Aug 2000 15:51:55 +0200
Message-ID: <8olo52$454$1_at_nereid.worldonline.nl>
Date: Thu, 31 Aug 2000 15:51:55 +0200
Message-ID: <8olo52$454$1_at_nereid.worldonline.nl>
"nicolas filla" <nfillat_at_atos-group.com> wrote in message
news:8ojbef$nca$1_at_pegase.production.axime.fr...
> does anyone know if it is possible to make a stored procedure that returns
> multiple rows just like a select do.
>
> It for using with java program
>
> thanks a lot
>
>
Try using a ref-cursor, your procedure will act like a select statement.
Greetings,
Peter Received on Thu Aug 31 2000 - 15:51:55 CEST