create or replace procedure pSleep (pSleepInMinutes NUMBER)
as
  vNow DATE := SYSDATE;
begin
  --
  procLog.info('INIT' || to_char(SYSDATE,'DD/MM/YYYY HH24:MI:SS'));
  --
  dbms_output.put_line('START: ' || to_char(vNow,'DD/MM/YYYY HH24:MI:SS'));
  --
  loop
    exit when vNow + (pSleepInMinutes * (1/1440)) <= SYSDATE;
  end loop;
  --
  procLog.info('END' || to_char(SYSDATE,'DD/MM/YYYY HH24:MI:SS'));
  --
  commit;
  --
  dbms_output.put_line('FINISH: ' || to_char(SYSDATE,'DD/MM/YYYY HH24:MI:SS'));
end;
/

Class.forName("oracle.jdbc.OracleDriver");

Connection connection = DriverManager.getConnection("jdbc:oracle:thin:@100.100.00.000:1521:database11g", "pass", "pass");
connection.setAutoCommit(true);

Statement stmt = connection.createStatement();
try {
        stmt.execute("ALTER SESSION SET NLS_LANGUAGE = 'AMERICAN'");
        stmt.execute("ALTER SESSION SET NLS_TERRITORY = 'AMERICA'");
} finally {
    stmt.close();
}
CallableStatement cs = connection.prepareCall("{call MYGRANT.pSleep(?)}");
cs.setInt(1, 180);
cs.execute();