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

How do you achieve the same result in VB5/VB6?

Alex

Thomas Kyte wrote in message <362ea564.176507564_at_192.86.155.100>...
>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.
Received on Sun Oct 18 1998 - 00:17:03 CEST