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

Home -> Community -> Usenet -> c.d.o.misc -> Re: recordset from ms-sql stored procedure

Re: recordset from ms-sql stored procedure

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Sat, 09 Aug 2003 09:43:36 -0700
Message-ID: <3F3524B8.840CB2ED@exxesolutions.com>


Rainer Hahnekamp wrote:

> Hello,
>
> I've created a database link from my Oracle9i to a SQL Server 2K and want to
> retrieve a recordset which is returned by a stored procedure.
> Is it possible to get this recordset also with a view or do I also have to
> create a stored procudure on oracle and what would be the syntax?
>
> Thanks in advance,
> -Rainer Hahnekamp

Go to http://tahiti.oracle.com and look up REF CURSOR.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Sat Aug 09 2003 - 11:43:36 CDT

Original text of this message

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