Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> About Return more tables from a PL/SQL procedure

About Return more tables from a PL/SQL procedure

From: Michael <michaelwah_at_tom.com.hk>
Date: 8 Jul 2004 03:45:43 -0700
Message-ID: <57aa0935.0407080245.3cbd3d8d@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. Received on Thu Jul 08 2004 - 05:45:43 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US