Re: About Return more tables from a PL/SQL procedure

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 8 Jul 2004 07:58:15 -0700
Message-ID: <2687bb95.0407080658.51072fc9@posting.google.com>

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