Re: Return a result set from a stored procedure into Delphi

A copy of this was sent to "mksoft" <mksoft_at_netvision.net.il> (if that email address didn't require changing) On Wed, 14 Oct 1998 13:31:20 +0200, you wrote:

>I'm trying to write a simple stored procedure that does the
>following :
>
>1) input a parameter into the procedure.
>2) Query a table based on the parameter
>3) call the procedure from delphi
>4) display the result set in a grid
>
>Somehow i could'nt get this to work.
>
>I'd appriciate a sample code describing the procedure.
>
>Thank you
>Meir
>MKsoft
>
>P.S.
>I'v read somewhere that PL/SQL isn't designed to return result sets.
>is it correct ? I's there a way to bypass this ?

totally incorrect and yes.

>
>

See http://www.dejanews.com/getdoc.xp?AN=262869760 for the answer... Asked and answered a while ago on these groups... I just searched for

Delphi & 'result set'

in dejanews in the comp.databases.oracle.* groups...  

Thomas Kyte
tkyte_at_us.oracle.com
Oracle Government
Herndon VA

--
http://govt.us.oracle.com/    -- downloadable utilities
 
----------------------------------------------------------------------------
Opinions are mine and do not necessarily reflect those of Oracle Corporation
 
Anti-Anti Spam Msg: if you want an answer emailed to you, 
you have to make it easy to get email to you.  Any bounced
email will be treated the same way i treat SPAM-- I delete it.