Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Returning a result set from a table using a stored procedure
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
![]() |
![]() |