Re: EXEC syntax for SP which returns row set

From: Mark Townsend <markbtownsend_at_comcast.net>
Date: Thu, 14 Jul 2005 21:10:03 -0700
Message-ID: <ruGdnXyLJ4xcq0rfRVn-og@comcast.com>

Mark A wrote:

>
> Returning a JDBC result set from an Oracle stored procedure, by Bruce P.
> Blackshaw
> http://www.enterprisedt.com/publications/oracle/result_set.html
>

Well... despite the title, this example is not returning a JDBC result set from an Oracle stored procedure at all. If you look closely you will see that the example uses a function, and not an SP at all.

CREATE OR REPLACE FUNCTION sp_get_stocks(v_price IN NUMBER)

RETURN types.ref_cursor
....

Which is the point that I think David is making.

And if you are going to return a value from an SP (as opposed to a function), then you do need to have out parameters. Received on Thu Jul 14 2005 - 23:10:03 CDT