When compiling large PL/SQL package, Oracle SQL Developer reports "Error: IO Error: Connection reset by peer: socket write error"

johanpre44 Dec 1, 2014 7:18 AM

When compiling large PL/SQL package, Oracle SQL Developer reports "Error: IO Error: Connection reset by peer: socket write error".

I also tried to recompile using a new SQL Developer instance (old instance was closed). The Package Code is about 10600 lines and 620kb.

I do not get this error when compiling any other code. One of my colleagues had no problems compiling it with Toad.

I'm running the Latest Oracle SQL Developer (4.0.3.16.84) and the latest Java 7 version (1.7.0_72).

1. Re: When compiling large PL/SQL package, Oracle SQL Developer reports "Error: IO Error: Connection reset by peer: socket write error"

thatJeffSmith-Oracle Dec 1, 2014 1:40 PM (in response to johanpre44)

Could you have the DBA check the alert logs? We're just sending the code to to the database to be executed - but over JDBC, which might be why you don't see an issue using other tools like SQL*Plus
Like Show 0 Likes(0)

Actions
2. Re: When compiling large PL/SQL package, Oracle SQL Developer reports "Error: IO Error: Connection reset by peer: socket write error"

johanpre44 Dec 2, 2014 3:39 AM (in response to thatJeffSmith-Oracle)

Will chat to the DBA's, thanks for the suggestion.
Like Show 0 Likes(0)

Actions