Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: recordset from ms-sql stored procedure
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
![]() |
![]() |