We have migrated our web api to SnapDevelop 2.0. It runs on a Windows 10 machine using an Oracle 11g database. The api method below worked fine in SnapDevelop 1.0 but now after the migration we are getting the attached exception. During the migration we found that we could not use the Datawindow Converter with an 11g database so we came up with a workaround for that by connecting to a shell 12c database that only had the schema.
Is the issue we are experiencing here due to the fact that SnapDevelop 2.0 does not support Oracle 11g? I looked at the definition for ExecuteProcedure and it doesn't appear to have changed.
Thanks, Tom
public void GetItemDescription(double? ad_param1, string as_param2, int? ad_param3, string as_table, out string as_description)
{
var procedureName = "CONVERT_LONGS";
as_description = String.Empty;
// Sets the parameter values.
var id1 = ParamValue.New<double?>("id1", ad_param1);
var id2 = ParamValue.New<string>("id2", as_param2);
var id3 = ParamValue.New<int?>("id3", ad_param3);
var table = ParamValue.New<string>("table_name", as_table);
var output = ParamValue.New<string>("outDesc", ParameterDirection.Output);
var result = _dataContext.SqlExecutor.ExecuteProcedure(procedureName,id1, id2, table, id3, output);
as_description = output.Value.ToString();
}
Thanks, Tom