Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Returning a result set from a table using a stored procedure

Re: Returning a result set from a table using a stored procedure

From: Graeme Humphrey <graeme.humphrey_at_prosoftres.co.uk>
Date: Tue, 7 Jul 1998 13:01:34 +0100
Message-ID: <35a20d2f.0@newsread1.dircon.co.uk>


Any ideas how to do this in Visual C++ v1.52?

Scott Cote wrote in message <35A1022C.BC291B8A_at_contractor.net>...
>Look at using reference cursors (and binding the cursor to your host
>programming lang.).
>
>SCott
>Hive Software, Inc.
>
>Ajay Soni wrote:
>
>> Hi,
>>
>> We're trying to return a table by calling a stored procedure which has a
>> select clause inside ( which looks like SELECT * FROM MYCUSTOMERS ).
>>
>> Example:
>>
>> >EXECUTE GET_CUSTOMERS
>>
>> Returns:
>>
>> Surname Firstname Address
>> ---------------------------------------------------------------------
>> Smith John 123 Broadway
>>
>> We know it's possible to do it in MSQL Server, but how can it be done in
>> Oracle 7.x
>>
>> Cheers
>>
>> Ajay
>
>
>
Received on Tue Jul 07 1998 - 07:01:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US