<div>
DECLARE<br />
&nbsp; &nbsp; &nbsp;exc ora_java.jobject;<br />
&nbsp; &nbsp; &nbsp;. . .<br />
&nbsp; BEGIN<br />
&nbsp; &nbsp; &nbsp;[ do some operations ]<br />
&nbsp; EXCEPTION<br />
&nbsp; &nbsp; &nbsp;WHEN ORA_JAVA.EXCEPTION_THROWN THEN<br />
&nbsp; &nbsp; &nbsp; &nbsp; exc := ORA_JAVA.LAST_EXCEPTION;<br />
&nbsp; &nbsp; &nbsp; &nbsp; MESSAGE(Exception_.getMess<wbr />age(exc));<wbr /><br />
&nbsp; &nbsp; &nbsp; &nbsp; ORA_JAVA.CLEAR_EXCEPTION;<br />
&nbsp; END;<br />
<br />
found this, hope this helps.<br />
<br />
daniels
</div>


DECLARE
     exc ora_java.jobject;
     . . .
  BEGIN
     [ do some operations ]
  EXCEPTION
     WHEN ORA_JAVA.EXCEPTION_THROWN THEN
        exc := ORA_JAVA.LAST_EXCEPTION;
        MESSAGE(Exception_.getMessage(exc));
        ORA_JAVA.CLEAR_EXCEPTION;
  END;

found this, hope this helps.

daniels

<div>
Hi daniels,<br />
<br />
I checked out your suggestion, but it only works in Forms &amp;&nbsp;Reports 9i, not in PL\SQL.<br />
<br />
Instead, I found this:<br />
<a href="http://www.unix.org.ua/orelly/oracle/guide8i/ch09_08.htm" rel="ugc">http://www.unix.org.ua/orelly/oracle/guide8i/ch09_08.htm</a><br />
<br />
under:<br />
&quot;9.8.5 Exception Handling with Java&quot;.<br />
This looks like it could be useful, even if it is not the most elegant solution...<br />
<br />

</div>


Hi daniels,

I checked out your suggestion, but it only works in Forms & Reports 9i, not in PL\SQL.

Instead, I found this:
http://www.unix.org.ua/orelly/oracle/guide8i/ch09_08.htm [http://www.unix.org.ua/orelly/oracle/guide8i/ch09_08.htm]

under:
"9.8.5 Exception Handling with Java".
This looks like it could be useful, even if it is not the most elegant solution...



<div>
<div class="content wysiwyg-content">
I loaded a Java class into the DB, and wrapped it with a pl\sql package.<br />
<br />
I would like to know if there is a way to catch exceptions thrown by the Java class and handle them in the pl\sql package?<br />
<br />
Thanks,<br />
Yoni. 
</div>
</div>


I loaded a Java class into the DB, and wrapped it with a pl\sql package.

I would like to know if there is a way to catch exceptions thrown by the Java class and handle them in the pl\sql package?

Thanks,
Yoni. 

Handling Java Exceptions from PL/SQL Code

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.