Call pl/sql function from Java

[egavish]

This is what the developer is trying to use (NO SUCCESS)
...why?:

CallableStatement cs = db.getConnection().prepareCall("{call SF_DAYS(?,?,?)}");
cs.setString(1,"US");
cs.setDate(2,new Date(2000,9,9));
cs.setString(3,"B");
// cs.registerOutParameter(4, java.sql.Types.INTEGER);
cs.execute();
int nDays = 0;
cs.getInt(nDays);

My function is:

create or replace function sf_days(CountryCode varchar2,ProcessDate date,Daystype varchar2)
return number

...


Thanks