Raise an Exception in PL/SQL but not got @ JAVA End

[Shaan Shar]

Hi Friends,

I have raised an exception in PL/SQL Stored Procedures which is of catagory "WHEN OTHERS THEN" Now here I wrote "RAISE" as the last statement. I was calling this SP from JAVA but when I ran this program, I found that at Oracle side the exception was raised, I mean excution went in exception block but neverthless I haven't received that exception as a SQLException in JAVA.

It's strange behaviour for me, Could anyone help me out. I am attaching the code snippet here below...
*********SQL Stored Procedure************
WHEN OTHERS THEN
p_status := Pkg_PalletHosp.cons_error;
RAISE;
*********SQL Stored Procedure************

And java snippet is as follows:

********JAVA Snippet**************

try {
cs =
con.prepareCall(
SLSPalletHospitalSQL.CALL_PROCESS_UNIDENTIFIED_PALLET);
cs.execute();
logger.info("SP Called Sucessfully ");
} catch (SQLException sqlException) {
logger.error(
"SQL Exception Occured during Sored Procedure Call",
sqlException);
throw new SLSDataException(
SLSException.SLS_SEVERITY_ERROR,
sqlException.getErrorCode(),
"Unable to process Request");
}

********JAVA Snippet**************

But execution is not passing through Catch Block.......

[Jeanne Boyarsky]

Ankur,
It looks like a different exception is being thrown. Your best bet would to be to catch (and output) that so we have more information about what is going on.