Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> How to debug java stored procedure
I am trying to debug a java stored procedureon Oracle 10.2.
It has always worked fine on Oracle 8 and 9 so have never needed to debug.
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?
CREATE OR REPLACE AND COMPILE JAVA SOURCE NAMED "function_os_command" AS
import java.io.*;
import java.util.*;
public class function_os_command
{
public static int Run(String Command)
{
int rc = 0;
try
{
Runtime rt = Runtime.getRuntime();
Process p = rt.exec(Command);
try {
rc = p.waitFor(); } catch (InterruptedException intexc) { rc = 2; }
rt.gc();
} catch (Throwable t) { rc = 3; }
return(rc);
}
}
/
John
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 25 2006 - 04:14:29 CDT
![]() |
![]() |