Very Computer

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!

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

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