Call pl/sql function from Java

[shailendra]

CallableStatement cstmt = conn.prepareCall("{? = CALL balance}");
cstmt.registerOutParameter(1,Type.FLOAT);
cstmt.setInt(2,acctno);
cstmt.executeUpdate();
float acctBal = cstmt.getFloat(1);


OR

u can directly execute query
for e.g
ur function name is fun_checkaccess and u r passing one parameter
u can write query like this

select fun_checkaccess(inputparameter) from dual;