Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

"ORA-00351: Network Library: Name-Value premature end of string" when using 4.112.3.60

raedwa01Jun 20 2013 — edited Jun 21 2013

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?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 19 2013
Added on Jun 20 2013
1 comment
12,382 views