This is a discussion on Correct Syntax for executing stored procedure with parameters on Oracle within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> I am trying to figure out the correct syntax for executing a stored procedure on a remote Oracle server. ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I am trying to figure out the correct syntax for executing a stored procedure on a remote Oracle server. The stored procedure has 2 input parameters and the Oracle server is defined as a Linked Server under SQL Server 2000. I can make selections of tables on the Oracle server. The following example I already tried, without success: Exec ORACLENAME..USER.SP input1,input2 and SELECT * FROM OPENQUERY(ORACLENAME,'BEGIN USER.SP(input1,input2) end Can someone help me. I know to little of Oracle (SQL Server) to find this out myself in reasonable amount of time. |