Getting data into SQL server from a ref cursor Oracle procedure. -- sql server odbc

vikrantd NO[at]SPAM online.microsoft.com
8/14/2003 9:07:03 PM

Hello Kevin,

Thank you for posting to the MSDN Managed newsgroups. We are acknowledging
your post and you should receive response from the community within 2
business days of your post. If you do not receive a response with in 2
business days or you believe there may be a problem with your subscription
please contact MSDN Managed feedback alias at ngmsdnfb@microsoft .com .

Please be sure to include the following information
No-spam alias:
Location of post:
Subject Line:

Are you receiving all the benefits as an MSDN subscriber?

New!! Post Notification : Get notified once your post has been responded
to, by the community or a Microsoft employee, directly to your designated
email account. To find out more about this service please contact the MSDN
Managed newsgroup alias

No-Spam Alias : Don’t subject your personal email or corporate email to
potential spam. Get a No-spam alias. For more information please visit the
following link.
http://support.microsoft.com/default.aspx?scid=/servicedesks/msdn/nospam.asp
&SD=msdn

Thank you posting to the MSDN managed newsgroups

Vikrant Dalwale

Microsoft SQL Server Support Professional

This posting is provided "AS IS" with no warranties, and confers no rights.
Get secure !! For info, please visit http://www.microsoft.com/security.
Please reply to Newsgroups only.

--------------------
[quoted text, click to view]

v-rxwang NO[at]SPAM online.microsoft.com
8/19/2003 6:38:23 AM

Hi Kevin,

I wonder if you are going to call Oracle stored procedure in TSQL through
linked server. Currently SQL Server 7/2000 doesn't support executing remote
stored procedures against a database other than SQL Server itself. This
functionality might be supported in our next SQL version.

Sincerely,

William Wang
Microsoft Partner Online Support

Get Secure! - www.microsoft.com/security
=====================================================
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from your issue.
=====================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
--------------------
| Content-Class: urn:content-classes:message
| From: "kevin" <kevin.chin@ey.com>
| Sender: "kevin" <kevin.chin@ey.com>
| Subject: Getting data into SQL server from a ref cursor Oracle procedure.
| Date: Wed, 13 Aug 2003 19:14:41 -0700
| Lines: 7
| Message-ID: <090c01c36209$d232fb10$a401280a@phx.gbl>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="iso-8859-1"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
| Thread-Index: AcNiCdIywQlSYKpnSii3FD+4NFHxyQ==
| Newsgroups: microsoft.public.sqlserver.odbc
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.odbc:39468
| NNTP-Posting-Host: TK2MSFTNGXA12 10.40.1.164
| X-Tomcat-NG: microsoft.public.sqlserver.odbc
|
| Which is the best way to get data from an Oracle stored
| procedure that is returning a ref cursor to SQL server.
| The data returning in the ref cursor is a unoin of rows
| that will be saved in a table.
|
| Can this be done without creating a separate application
| between the two databases.
|

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server odbc

sql server odbc : Getting data into SQL server from a ref cursor Oracle procedure.