How To Call Stored Function Of In And Out Parameter In Oracle Database Using Java

public String getObjectDetails(String buffer) { dbcon con = new dbcon(); ResultSet rs = null; String name_msg=null; String type_msg=null;

Solution 1:

try this

CallableStatementc= conn.prepareCall("{? = call get_object_type(?, ?)}");
    c.registerOutParameter(1, Types.VARCHAR);
    c.registerOutParameter(3, Types.VARCHAR);
    c.setString(2, buffer);
    c.execute();
    Stringres= c.getString(1);
    Stringerr= c.getString(3);

Solution 2:

This works for me, thanks @home to suggesting me good link.

Stringcall = "{ ? = call pkg_test1.get_object_type(?,?,?)}";
CallableStatement cstmt = con.dbstate().prepareCall(call);
 cstmt.registerOutParameter(1, oracle.jdbc.OracleTypes.VARCHAR);
cstmt.setString(2, buffer);
cstmt.registerOutParameter(3, oracle.jdbc.OracleTypes.NUMBER);
cstmt.registerOutParameter(4, oracle.jdbc.OracleTypes.VARCHAR);
cstmt.executeQuery();
String type = cstmt.getString(1);

Well Explained Here : How to Call Strored Procedure and Function