"Mark Townsend" <markbtownsend_at_comcast.net> wrote in message
news:ruGdnXyLJ4xcq0rfRVn-og_at_comcast.com...
> 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.
>
I am still a bit confused about the function vs. SP issue, especially since
the link says SP but uses a function.
But as I said, I was just trying to quickly test the SP/Function from
SQL*Plus, and completely recognize that additional code is necessary to get
the result set in java (what our programmers use).
Received on Thu Jul 14 2005 - 23:30:03 CDT
