This week's book giveaway is in the OO, Patterns, UML and Refactoring forum. We're giving away four copies of Refactoring for Software Design Smells: Managing Technical Debt and have Girish Suryanarayana, Ganesh Samarthyam & Tushar Sharma on-line! See this thread for details.
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
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