Re: How to call an Oracle Stored procedure from MSSQL Server Stored Procedure

From: Eric Levinson <nospam_at_nospam.com>
Date: Fri, 18 Oct 2002 17:21:36 GMT
Message-ID: <AqXr9.41677$Ik.913465_at_typhoon.sonic.net>

Does the OpenQUERY allow the call of stored procedures with parameters and return values from functions? It doesn't look like it from the examples.

I can't really find many examples which show in MSSQL Transaction SQL how to populate parameters, call the function/procedures, and then bind back the OUT parameters or returned values in functions. Anyone know where I can get examples of this? I have been looking on websites, etc. Do I have to use ADO, or can I just use straight ODBC?

Eric

"Anith Sen" <anith_at_bizdatasolutions.com> wrote in message news:eSBy8dYdCHA.1260_at_tkmsftngp12...
> I have not done this but you should be able to use
> OPENQUERY to accomplish what you are trying to do. Take a
> peek at :
> http://tinyurl.com/216p
>
> --
> - Anith
>
>
Received on Fri Oct 18 2002 - 19:21:36 CEST

This message: [ Message body ]
Next message: Kenneth C Stahl: "Re: Oracle personal edition?"
Previous message: Daniel Morgan: "Re: How to find the Database version without opening the Database"
Maybe in reply to: Eric Levinson: "How to call an Oracle Stored procedure from MSSQL Server Stored Procedure"
In reply to Anith Sen: "Re: How to call an Oracle Stored procedure from MSSQL Server Stored Procedure"
Next in thread: Kenneth C Stahl: "Re: Oracle personal edition?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message