Re: Returning result set from a stored procedure?

A copy of this was sent to Anders Permats <anders_at_webgiro.com> (if that email address didn't require changing) On Wed, 22 Dec 1999 15:25:15 +0100, you wrote:

>Hi,
>
>This is probably a common question, but I am unable to find a good
>answer to it.
>
>How do I return a result set from a stored procedure in Oracle?
>I am using Java and JDBC and we are accessing several databases like
>InterBase and Sybase.
>We always use stored procedures to interface the databases also when
>retrieving information.
>So we would like to NOT use any special tricks like passinng cursor
>handles or array output
>parameters in Oracle.

that is not a trick -- that is the way it is done, it is the only way to do it in Oracle.

>However if those tricks are the only way to do it, does anyone know how
>to do it or know of an FAQ
>or something that describes how.
>

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

>Or do everybody still use plain SQL in the code?
>
>Thanks in advance!
>
>Best regards
>
>Anders Permats
>

--
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 Wed Dec 22 1999 - 10:03:51 CST