RE: How to debug java stored procedure

John

>It is returning a return code(rc) of 3.
>How do I find out what the actual exception was. I presume I need to get
>more info out of the obejct t but not being a java programmer I don't know
>how
>
>Can any one help?

Replace the line:

> } catch (Throwable t) { rc = 3; }

With:

> } catch (Throwable t) { rc = 3; t.printStackTrace(); }

Then, when you execute the method and an exception is generated, you should get a trace file under UDUMP.

HTH
Chris

PS: My guess is that you have a problem with privileges...

--
http://www.freelists.org/webpage/oracle-l