November 19, 2004 at 5:36 am
I have a major problem which I have been so far unable to resolve. I wish to be able to call a procedure in an Oracle database from SQL Server.
I know I can set up Oracle as a remote server and query table in that database but I need to be able to call in with a set of parameters and get a response from the database. I have attempted to do this but it appears that it is not possible, even microsoft don't know how to do it.
Does anyone know of a way of doing this even if it involves a third party product?
Thanks
Terry
November 22, 2004 at 8:00 am
This was removed by the editor as SPAM
November 26, 2004 at 11:00 am
We've addressed this same kind of problem in two different ways - both have been less than 100% satisfactory:
1- Best way so far is to execute Java or C# executable from task scheduler - executable accesses Oracle database, executes the Oracle package with parameters and returns what we need
2- SQL Server stored procedure can be written with parameters to execute SELECT queries to the Oracle database. Need to use Oracle-compatible syntax but it does work.
DZ
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply