dear all I have the following syntax below
private DataTable obtain_fn()
{
DataTable dt = new DataTable();
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("finance.pkg_test.get_name");
string selectsql = sb.ToString();
using (Utility.OracleHelper obj = new Utility.OracleHelper(oraConnectionString))
{
dt = obj.GetDataTable(selectsql);
}
return dt;
}
basically the name of my package is pkg_test and it is in the finance schema and the name of the function in the package is called get_name
However everything I run that function, it is gives me an error.
...
Go to the complete details ...