Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: About Return more tables from a PL/SQL procedure
michaelwah_at_tom.com.hk (Michael) wrote in message news:<57aa0935.0407080245.3cbd3d8d_at_posting.google.com>...
> I am converting some Stored Procedure from T-SQL to PL/SQL.
>
> The T-SQL procedure return many table from database,
> and it is called from JDBC.
> how can PL/SQL do something like this ??
>
> Most of examples on web using a PL/SQL function which
> return a REF CURSOR, but this can only return one table.
>
> Thanks for your help.
I have never tried it but you should be able to return more than one ref cursor from a single procedure with each reference cursor returning one table (so to speak).
HTH -- Mark D Powell -- Received on Thu Jul 08 2004 - 09:58:15 CDT
![]() |
![]() |