Re: Cursors in Stored Procedures and JDBC

A copy of this was sent to "Sonia Gillespie" <sonia_gillespie_at_lagan.com> (if that email address didn't require changing) On Thu, 10 Feb 2000 10:44:26 -0000, you wrote:

>I've been trying to set up a cursor within a procedure in order to return a
>number of rows into a result set via jdbc. However, I have been unable to
>achieve this. I can set up a simple procedure and execute it within SQL
>Plus, but have been unable to do this from my Java program.
>
>I would really appreciate it if someone could just provide me with
>guidelines concerning the set up of the cursor in the procedure, and how to
>execute this from java!
>
>Can ANYONE help me???
>
>Sonia.
>

see http://osi.oracle.com/~tkyte/ResultSets/index.html

example is there.

--
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 Thu Feb 10 2000 - 06:36:55 CST