Dfyjkt

im doing an insert to table EMPLOYEES:

EMPLOYEE_ID NUMBER(6,0) 
FIRST_NAME VARCHAR2(20 BYTE) 
LAST_NAME VARCHAR2(25 BYTE)
EMAIL VARCHAR2(25 BYTE)
PHONE_NUMBER VARCHAR2(20 BYTE)
HIRE_DATE DATE
JOB_ID VARCHAR2(10 BYTE) 
SALARY NUMBER(8,2)
COMMISSION_PCT NUMBER(2,2) 
MANAGER_ID NUMBER(6,0) 
DEPARTMENT_ID NUMBER(4,0) 

I call to this SP from java:

create or replace PROCEDURE SP_EMPLOYES_INSERT 
(
 FIRST_NAME IN EMPLOYEES.EMPLOYEE_ID%TYPE 
, LAST_NAME IN EMPLOYEES.LAST_NAME%TYPE 
, EMAIL IN EMPLOYEES.EMAIL%TYPE 
, PHONE_NUMBER IN EMPLOYEES.PHONE_NUMBER%TYPE 
, HIRE_DATE IN EMPLOYEES.HIRE_DATE%TYPE 
, JOB_ID IN EMPLOYEES.JOB_ID%TYPE 
, SALARY IN EMPLOYEES.SALARY%TYPE 
, COMMISSION_PCT IN EMPLOYEES.COMMISSION_PCT%TYPE 
, MANAGER_ID IN EMPLOYEES.MANAGER_ID%TYPE 
, DEPARTMENT_ID IN EMPLOYEES.DEPARTMENT_ID%TYPE 
, C_EMPLOYE OUT SYS_REFCURSOR
) IS
EMP_ID EMPLOYEES.EMPLOYEE_ID%TYPE;
MENSAJE VARCHAR2(1000);
BEGIN

 SELECT (NVL(MAX(EMPLOYEE_ID),0) + 1) INTO EMP_ID FROM EMPLOYEES;
 INSERT INTO EMPLOYEES(EMPLOYEE_ID,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID)
 VALUES(EMP_ID ,FIRST_NAME,LAST_NAME,EMAIL,PHONE_NUMBER,HIRE_DATE,JOB_ID,SALARY,COMMISSION_PCT,MANAGER_ID,DEPARTMENT_ID);
 MENSAJE:= 'Se inserto con exito';

 OPEN C_EMPLOYE FOR
 SELECT MENSAJE MSG FROM DUAL;

 EXCEPTION
 WHEN OTHERS THEN
 MENSAJE:= SQLERRM;
 OPEN C_EMPLOYE FOR
 SELECT MENSAJE MSG FROM DUAL;
 --DBMS_OUTPUT.PUT_LINE(SQLERRM);

END SP_EMPLOYES_INSERT;

And the code in java is:

 public boolean PutEmployee(int action) throws SQLException
 
 boolean result = false;
 Connection con = null;
 CallableStatement stmt = null;
 ResultSet rs = null;
 String mensaje = null;

 try 
 
 catch(Exception ex)
 
 System.out.print(ex.getMessage());
 result = false;
 
 finally
 
 if(con!=null)
 con.close();
 if(rs !=null)
 rs.close(); 
 
 return result;
 

And i get an error in the catch: ORA-01722: "número no válido" when i do the execute in the callablestatement.

I dont know how to cast java double to number(8,2), number(2,2).
Anyone kwnow how i could insert this ?

Im puting this values to the object employee:

 empService.objEMPLOYE.setCommissionPct(0.3);
 empService.objEMPLOYE.setDepartmentId(3);
 empService.objEMPLOYE.setEmail("asd@hotmail.com");
 empService.objEMPLOYE.setFirstName("Matias");
 empService.objEMPLOYE.setHireDate(new java.sql.Date(2018, 11, 10));
 empService.objEMPLOYE.setJobId("a1");
 empService.objEMPLOYE.setLastName("Perez");
 empService.objEMPLOYE.setManagerId(1);
 empService.objEMPLOYE.setPhoneNumber("1545659865");
 empService.objEMPLOYE.setSalary(150.3);

Any idea?
Thanks!