Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Stored procedure that return multiple records
you can use a ref cursor as an out parameter of a stored proc.
It's works fine
"Norhamizan Arifin" <mizan_at_mimos.my> a écrit dans le message de news:
3C61F46A.E362FF0B_at_mimos.my...
> I hope this is a correct group to discuss about my problem.
>
> I need to create an Oracle stored procedure that could return multiple
> records (rows). This stored procedure will be execute by Java program. I
> understand that Java can do this. But I don't know how to do it.
>
> I know that I could create a stored procedure that will write to a
> temporary table, then the Java program will just need to select from
> that table. But, due to certain constrains, I could not do that way.
>
> I hope somebody could help me.
>
> Thank you in advance.
>
> Regards,
> ../Mizan
Received on Fri Feb 08 2002 - 08:48:26 CST