SQL & PL/SQL

I'm running shell commands from an Oracle db (11gr2) on aix.
But, I would like to get a return value from a shell comand... like you get with "echo $?"

I use a code like

CREATE OR REPLACE JAVA SOURCE NAMED common."Host" AS
import java.io.*;
public class Host {
  public static int executeCommand(String command) {
    int retval=0;
    try {
        String[] finalCommand;
        finalCommand = new String[3];
        finalCommand[0] = "/bin/sh";
        finalCommand[1] = "-c";
        finalCommand[2] = command;

      final Process pr = Runtime.getRuntime().exec(finalCommand);
      pr.waitFor();
}
   catch (Exception ex) {
      System.out.println(ex.getLocalizedMessage());
      retval=-1;
    }
    return retval;
};
/

but I do not get a return value... because I don't know how to get return value..

Edited by: user9158455 on 22-Sep-2010 07:33