How to Execute a Packet on DataBase
I have to Execute the Procedure as:
"exec pack_context.context_open(to_date('01/31/2011','mm/dd/yyyy'), 6);"
I had used "ADODB.Command" & "ADODB.Recordset" objects to execute the Package but getting an error Syntext Error or Access Voilation.
I here by sharing the code I had used to execute the Packet as:
strPack = "exec pack_context.context_open(to_date('01/31/2011','mm/dd/yyyy'), 6);"
Set objCon = CreateObject("ADODB.Connection")
Set objRS = CreateObject("ADODB.Recordset")
Set oADO_CMD = CreateObject("ADODB.Command")
oADO_CMD.ActiveConnection = objCon
oADO_CMD.CommandType = 4
oADO_CMD.CommandText = strPack
I had tried with: Set objRS = objCon.Execute(strPack)
But getting the same error.
If someone had encountered such kind of problem or there is some different way to execute the above packet then please share your thoughts with me.
Thanks in advance.