SQL Server Performance Forum – Threads Archive

execute oracle stored procedure by DTS(ActiveX )

HI, I want to execute a Stored Procedure on a Oracle DB from a DTS package(from a Active X Script task).
I have used the following syntax.
I am getting error at the line –
objCmd.CommandType = adCmdStoreProc.
Can u pls help me out if there is any error in the syntax.
Dim objConn,objrecordset,objCmd
Set objConn = CreateObject("ADODB.Connection")
Set objCmd = CreateObject("ADODB.command") objConn.Open "Provider=msdaora.1;" & _
"Data Source= Test_Oracle;" & _
"User Id=test;" & _
"Password=test1" objCmd.Activeconnection = objConn
objCmd.CommandType = adCmdStoreProc
objCmd.CommandText = "ISO.TEST"
objCmd.execute objConn.close
set objConn = Nothing
Oracle Instance trying to connect – Test_Oracle
Name of the Stored procedure to execute = ISO.TEST I have checked the connection .It is succesful. Pls advice. Thanks,
ks.

---

Try this….. Set objCmd= Server.CreateObject("ADODB.Command")
Set objCmd.ActiveConnection = objConn objCmd.CommandText = "{call ISO.TEST}"
objCmd.CommandType = adCmdText
Raulie
HP

---

]]>