neat way to send excpetion back to java

[manish ahuja]

Hi all
We have certain j2ee components (jsp, servlets)
which invoke our stored procedures in Oracle databse
in our plsql code we log the exception in an error log table
. we dont raise it as we dont explicitly have commit & rollback in our stored procs.
if we raise ,the entry in the error log is rolled back
all transaction mgmt is handled by Java.
What i want to acheive is a neat way to communicate the exception bak to JAVA
Rgrds

[Avi Abrami]

Hi Manish,
If your version of Oracle supports it (sorry, I saw no details of your Oracle version in your post), you can use an "autonomous transaction" to insert a row into your log table. Just do a search for "autonomous transaction" at the following Web sites:
http://otn.oracle.com
http://asktom.oracle.com
http://metalink.oracle.com
http://tahiti.oracle.com
http://forums.oracle.com
Good Luck,
Avi.
[ November 20, 2003: Message edited by: Avi Abrami ]

[manish ahuja]

Hi Avi
Regarding Oracle version , its 817
I have tried pragma autonomous_transaction for logging errors into a error log table & then raise it bak to java
but we are using Weblogic(which is configured in such a way) that any commits, rollbacks or pragma autonomous_transaction i have on the database side , the weblogic throws an error
Rgrds