Re: please help! oracle stored procedure and jdbc

A copy of this was sent to "Gary T. Mui" <gmui_at_prescientmarkets.com> (if that email address didn't require changing) On Tue, 2 Nov 1999 09:14:48 -0500, you wrote:

>I am getting desperate in trying to implement something that I have not been
>able to figure out (I have only used sybase till now) and have not gotten
>much help from a couple Oracle DBA's.
>
>Is it possible to create an oracle stored procedure that will simply allow
>me to query for multiple rows? I.e. can I execute a stored procedure that
>might have a few parameters but basically does a 'select c1, c2, c3 from x'?
>I'm looking for the oracle equivalent of this sybase procedure:
>
>create proc selectX as
>{
> select c1, c2, c3 from x;
>}
>
>I understand that I will probably need to use cursors somehow, but I'm new
>to oracle and haven't found a single example anywhere that can do this. Is
>this possible?
>
>The second thing is that I want to call these procs from a java app using
>JDBC.
>
>Any help would be greatly, greatly appreciated.
>
>Thanks,
>Gary Mui
>gmui_at_prescientmarkets.com
>
>

See the howto on returning result sets from stored procedures at the URL in my signature. java example included there as well.

--
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Tue Nov 02 1999 - 08:21:49 CST