I am trying to do a straight replace of the DataAccess Client. I updated my connection string to be <add name="Oracle" connectionString="Data Source=oracle;User Id=Scott;Password=Tiger;" />. I set my "oracle.manageddataaccess.client" section to have a dataSource of :
<dataSource alias="oracle" descriptor="(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT = 1111))(CONNECT_DATA=(SERVICE_NAME=MYORACLE)(SERVER = DEDICATED))" />
I run a query that gets executes a proc in a package as follows:
const string query = "select * from table(MYPACKAGE.get_records())";
var retVal = new DataSet();
_orComm = new OracleCommand(query, _orConn);
var oDA = new OracleDataAdapter(_orComm);
_orComm.CommandType = CommandType.Text;
_orComm.CommandTimeout = CommandTimeout;
_orConn.Open();
oDA.Fill(retVal, "values");
return retVal;
I get an exception when running that matches the title though.
What am I doing wrong?