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

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 08 Jul 2004 17:53:55 -0700
Message-ID: <1089334451.72705@yasure>

Michael wrote:

> 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.

Write a stored procedure with multiple OUT parameters.

But, quite frankly, trying to duplicate functionality from T-SQL to PL/SQL is about as likely to lead to success as is spitting on the desk during a job interview.

Reconsider ... and duplicate functionality ... not methodology.

Daniel Morgan Received on Thu Jul 08 2004 - 19:53:55 CDT