Xref: alice comp.databases.oracle.server:24137 From: "Graeme Humphrey" Newsgroups: comp.databases.oracle.server References: <01bda8f6$921f7c00$9a6adec2@ajaytosh> <35A1022C.BC291B8A@contractor.net> Subject: Re: Returning a result set from a table using a stored procedure Date: Tue, 7 Jul 1998 13:01:34 +0100 Lines: 37 X-Newsreader: Microsoft Outlook Express 4.72.2106.4 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Message-ID: <35a20d2f.0@newsread1.dircon.co.uk> X-Trace: 7 Jul 1998 12:57:35 -0100, 194.112.58.48 Path: alice!news-feed.fnsi.net!news.maxwell.syr.edu!news-peer.gip.net!news-lond.gip.net!news.gsl.net!gip.net!nntp.news.xara.net!xara.net!news5.cableinet.net!peer1.news.dircon.net!peer2.news.dircon.net!newsread1.dircon.co.uk!news.dircon.co.uk!194.112.58.48 Any ideas how to do this in Visual C++ v1.52? Scott Cote wrote in message <35A1022C.BC291B8A@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 > > >