Hi,
We are getting an error "Oracle.DataAccess.Client.OracleException: Data provider internal error(-3000) [System.String]" while opening the Oracle connection.
Error message:
Oracle.DataAccess.Client.OracleException: Data provider internal error(-3000) [System.String]
at Oracle.DataAccess.Client.OracleException.HandleErrorHelper(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, OpoSqlValCtx* pOpoSqlValCtx, Object src, String procedure, Boolean bCheck, Int32 isRecoverable)
at Oracle.DataAccess.Client.OracleException.HandleError(Int32 errCode, OracleConnection conn, IntPtr opsErrCtx, Object src)
at Oracle.DataAccess.Client.OracleConnection.Open()
Oracle server: Oracle Database 12c Standard Edition Release 12.1.0.2.0 - 64bit Production
Oracle.DataAccess.dll: 2.121.2.0 (32bit client, patch 21126814)
Source code:
try
{
Console.WriteLine("Opening Oracle connection...");
OracleConnection connection = new OracleConnection(Settings.Default.ConnectionString);
connection.Open();
Console.WriteLine("Oracle connection opened successfully");
Console.WriteLine("Retrieving data from database...");
OracleCommand command = new OracleCommand("select * from sys_function",
connection);
OracleDataReader reader = command.ExecuteReader();
if (reader.HasRows)
{
while (reader.Read())
{
Console.WriteLine(reader.GetString(0));
}
}
Console.WriteLine("Data retrieved successfully");
Console.WriteLine("Press any key to exit");
connection.Close();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
Could you help us figure out what's going wrong? Thanks!
Regards,
Aeroth Lin