CreateADOStoredProc and a adVarChar Parameter
I am trying to call a Oracle Stored proc which returns a VarChar. But it seems to be having trouble recognising the type "adVarChar". I get the following error: "Arguments are of the ...
Forum Discussion
I got answer from SmartBear on my previous case to use such syntax - so DataType seems to be correct - quote:
Hello,
Here is code that should work for you
[C#Script]
// ...
Cmd["CommandText"] ="dbo.Bin_DeleteItems";
Cmd["CommandType"] = DB["adCmdStoredProc"];
var param = Cmd["Parameters"]["AddParameter"]();
param["Name"] = "XMLListOfIds";
param["DataType"] = DB["adPersistXML"];
param["Direction"] = DB["adParamInput"];
param["Value"] = XmlString;
RecSet = Cmd["Execute"]();
// ...
Best regards,
Jay
