How to call an Oracle Stored procedure from MSSQL Server Stored Procedure 
Author Message
 How to call an Oracle Stored procedure from MSSQL Server Stored Procedure

Anyone on this list know how to call an Oracle Stored procedure (a function
which returns a number) from within a Microsoft SQL Server stored procedure?

We are just using plain ODBC connections.  We have a function called func
and it takes 3 parameters, and returns a number.

The function is defined as:

func (str1, str2, str3) return NUMBER;

How, in SQL Server do I set up the three strings, then make the call, then
get the NUMBER.  I have seen a few articles on various web pages, but they
are primarily for procedures, not functions, and they use ADO.  I'm only
really interested in an ODBC  solution at the present time.

If you have any suggestions, or links, please email me at ericl at
broderbund dot com, or post your responses here.

Thanks!



Mon, 04 Apr 2005 06:57:50 GMT
 How to call an Oracle Stored procedure from MSSQL Server Stored Procedure

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



Mon, 04 Apr 2005 10:51:20 GMT
 How to call an Oracle Stored procedure from MSSQL Server Stored Procedure
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


Quote:
> 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



Wed, 06 Apr 2005 01:21:36 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Calling Oracle Stored Procedure from within SQL Server Stored Procedure

2. Calling Stored Procedure that calls Stored Procedure in ASP

3. Calling a Java Stored Procedure from another Java Stored Stored Procedure

4. Calling a stored procedure on another server from within a stored procedure

5. Tool for converting Store Procedure in SQL Server to Oracle Store Procedures

6. Stored Procedure calling Stored Procedure

7. Call a stored procedure from another stored procedure

8. Calling a stored procedure with parameters from another stored procedure

9. Calling a Stored Procedure from a Stored Procedure

10. Calling a stored procedure with parameters from another stored procedure

11. Stored procedure calls multiple stored procedures

12. Calling stored procedures from another stored procedure


 
Powered by phpBB® Forum Software