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.
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.
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".
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
