PL/SQL (MOSC)

MOSC Banner

Connection interrupted after call (by a java program) of a procédure PL/SQL that returns user except

edited Jul 6, 2011 6:25AM in PL/SQL (MOSC) 7 commentsAnswered
Hi,   

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;

/

--------------------------

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center