SQL & PL/SQL

Hello,

I am trying to debug a Java proc and I can not get the trace of a java exception from a call PROC_NAME (args) under sqlplus.

The class works fine as an external class using oci or thin.

It works fine as a stored proc if it does not try any delete/updating.

I have an other class build almost the same way that works fine as a delete/update handeler. The only main difference is that the new one uses an argument to the main method.

This one just hang for ever if I pass an argument that does fulfile the conditions dor an updates. I guessed that it is probably linked to some string handeling with the procedure declaration. To debug it I need to step in and be able to get any exception.

Under SQLPLUS I get the simple
sql> call alim_invoice ('10-2005');

Call completed.
even though I have forced an exception to stop before the hang.

As a Java class alimInvoce does throw it correctly.

*** Init executed ***
java.lang.Exception: Ya
at AlimInvoice.alimInv(AlimInvoice.java:150)
at AlimInvoice.main(AlimInvoice.java:87)
java.lang.Exception: Ya
*** It took : 1904 MiliSec to update the informations ***
***** AlimInvoice terminated *****

I have initialised my SQL session to get dbms_output.

SQL>set serveroutput on size 100000
exec dbms_java.set_output(1000000)

I am a bit at lost here. Anybody sees what i missed to get the stack (or the argument ;-])?

Cheers,

Philippe Laliberte