Connection interrupted after call (by a java program) of a procédure PL/SQL that returns user except
I have a procédure that returns sometimes user exception, this procédure is called by a java program.
After 16 calls with exception, the 17th call returns the following exception:
ORA-17002 : Erreur d'E/S: Software caused connection abort: recv failed
Then other calls for the procedure returns the exception:
ORA-17008 : Connexion interrompue
Example to reproduce this issue:
Create a package PACKAGE1 in a schéma testd1 :
--------------------------
CREATE OR REPLACE
PACKAGE PACKAGE1 AS
procedure testexception;
END PACKAGE1;
/
CREATE OR REPLACE
PACKAGE BODY PACKAGE1 AS
procedure testexception AS
BEGIN
raise_application_error(-20003,'test exception');
END testexception;
END PACKAGE1;
/
--------------------------