Error ORA-03111 break received on communication channel

asp.net asp.net-mvc entity-framework oracle oracle10g

Question

I've got error ORA-03111 Break received on communication channel after change from oracle 11g to oracle 10g R1 at different server.

I use DotNet framework 4.5.

I have google around but didnt find any solution.

1
4
4/30/2015 6:20:25 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

In my case (getting the exception on connection.Open()) the problem turned out to be that the Oracle server was too old a version to use the Managed Provider.

According to: https://community.oracle.com/thread/2528641

ODP.NET, Managed Driver supports connecting to Oracle DB server 10.2 or higher. It does not support DB 10.1.

4
6/25/2015 4:42:25 AM

Popular Answer

In my case the reason was that input to the NVL function returned more than one row - the blabla subquery in the following:

PROCEDURE my_procedure(c_my_cursor OUT SYS_REFCURSOR) IS
  p_my_cursor SYS_REFCURSOR;
BEGIN
  OPEN p_my_cursor FOR
  select nvl((select blabla), 0) my_column from my_table;
  c_my_cursor := p_my_cursor;
END smiley_alle_jurenheder;

Interestingly enough, when running the query directly in SQL Developer, the correct error code is returned - "ORA-01427: single-row subquery returns more than one row".

Martin Ørding-Thomsen

Related Questions

WCF - An error occurred while receiving the HTTP response to http://xxxxx/Service/

Found the root cause after a lot of swearing and thinking of how nice the weather is outside. I remove the virtual keyword from the UserDetails object that is inside the User object....Now it works!...As far as why this caused an issue, my assumptions are serialization or DbContext issues, but I will have to look more into it, not sure....I'm going...
c# ef-code-first entity-framework wcf
asked by ledgeJumper

Unity Bootstrapper (Unity.Mvc), Unity 3, MVC 5, EF6 Receiving Error: Parameterless Public Constructor on Controller

You need to set the DependencyResolver. I cant see the code in the example you provided where this is done....Once setting up your UnityContainer and registering your types, you need to set the ...System.Web.MVC.DependencyResolver....... DependencyResolver.SetResolver(new UnityDependencyResolver(container));
asp.net-mvc-5 c# dependency-injection entity-framework-6 unity-container
asked by daveo

Oracle.ManagedDataAccess.EntityFramework - ORA-01918: user 'dbo' does not exist

I solve this just setting the default schema at modelBuilder...protected override void OnModelCreating(DbModelBuilder modelBuilder) { modelBuilder.HasDefaultSchema("MyOracleSchema"); // ... }
code-first ef-migrations entity-framework odp.net oracle
asked by Thiago Lunardi

SqlException - A transport-level error has occurred when receiving results from the server

I am coding a MVC 5 internet application and I have a recurring task that executes every hour. This task updates some model objects using a DbContext class. The application is deployed as an Azure website....I am getting the following error every few hours:...System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred wh...
asp.net-mvc-5 c# entity-framework-6 hangfire sqlexception
asked by user3736648

ODP.Net Managed Driver - ORA-12704: character set mismatch in generated code

I never did find the proper solution to this, however I did find a workaround that works well....I created an Interceptor class ...NVarcharInterceptor... implementing ...IDbCommandInterceptor..., and overrode all of the .....Executing(..)... methods to contain the following code:...if (command != null && !string.IsNullOrWhiteSpace(command.CommandTe...
c# entity-framework-6 odp.net
asked by Nick

ORA 00936 error calling a PL/SQL stored procedure from a c# web service

I need some help calling a stored procedure designed to add sequence number to each row added by an Api POST method....At the moment I get this error message: "ExceptionMessage": "ORA-20001: Get Next Sequence Failed.. -936 ORA-00936: missing expression\nORA-06512: at \"FOO_BAR.PROC_NEXT_SEQUENCE\", line 19\nORA-06512: at line 1"...I have tried nume...
c# entity-framework-6 odp.net oracle stored-procedures
asked by Julian H

ORA-01450: maximum key length (6398) exceeded (Devart.Data.Oracle.OracleException)

First dataaccess method using entityframework fluent api , Dev Art in oracle database getting below error....actual table design :...this query failing.... CREATE TABLE DADeskSettings ( UserID NVARCHAR2(2000) NOT NULL, Password NVARCHAR2(2000) NOT NULL, DADeskURL NVARCHAR2(2000) NOT NULL, WebURL NVARCHAR2(2000) NOT NULL, IsDADeskSetting...
devart entity-framework-6 oracle
asked by anand

Receiving 500 internal server error even though I receive data from LINQ

In the action ...GetFood... you specified that the return type is ...Food.... By default the EntityFramework generate proxy objects around your entities for lazy-loading. ...Meaning that the line:... Food food = db.Foods.Find(id); ...Will not return a ...Food... object, but a dynamic subclass of food. This can also be seen in the error you posted i...
asp.net-web-api c# entity-framework-6 https
asked by RMH

ORA-00955: name is already used by an existing object; When using Oracle.ManagedDataAccess and EntityFramework

I am having a hard time working with EF and Oracle. Earlier, I have developed an app that use EF and Oracle and have ran well. I installed the ODAC in local computer (GAC) that contains Oracle.ManagedDataAccess and Oracle.ManagedDataAccess.EntityFramework....This time I develop an app that using EF and Oracle too, but I just want to use the NuGet p...
entity-framework-6 odp.net oracle
asked by grayfieldmm

Entity Framework 6 - ORA-00932 while joining with ToString

I'm testing out ...Entity Framework 6.2... with an oracle database but facing issues while trying to join on multiple conditions with convertion. ...I need to match ...TABLE2_ID (NUMBER)... with ...TABLE2.ID (VARCHAR2)... which are different value types. The problem is that the ...ToString()... method translates into ...TO_NCLOB... instead of ...T...
c# entity-framework entity-framework-6 linq oracle
asked by Daniel Bonhard

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow