public class EmpTest {  
       
      public void insertEmp() throws ClassNotFoundException, SQLException {  
      Class.forName("oracle.jdbc.driver.OracleDriver");  
      Connection conn = DriverManager.getConnection("jdbc:oracle:thin:@xxxx.xxx.xx.com:1521:abc", "user", "password");  
      String sqlQuery = "insert into emp_table "  
      + "(empid, empname)VALUES (?,?)";  
      PreparedStatement pstmt = conn.prepareStatement(sqlQuery);  
      pstmt.setString(1, "emp01");  
      pstmt.setString(2, "emp name");  
       
      pstmt.execute();  
      }  
    }  

 CREATE OR REPLACE PROCEDURE Insert_Records as  
    LANGUAGE JAVA NAME 'EmpTest.insertEmp()'