Raising exceptions from PLSQL to Java

Can a PL/SQL program raise an exception to a calling Java program (i.e. running on the server)?

I've tried using both RAISE and RAISE_APPLICATION_ERROR in the exception handling section of the PLSQL code. Neither seems to work.

Any suggestions?

Example PLSQL code:
  EXCEPTION
    WHEN OTHERS

       THEN BEGIN
           RAISE_APPLICATION_ERROR (-2001, SQLERRM);
      END;

thanks.

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Dec 30 1999 - 11:58:07 CST