Calling PL/SQL Function From OAF Page

 
import java.sql.CallableStatement;
import java.sql.SQLException;
import java.sql.Types;
import oracle.apps.fnd.framework.server.OADBTransactionImpl;

String outParamValue = null;
OADBTransaction txn = getDBTransaction();
CallableStatement cs = txn.createCallableStatement ("begin :1 := xx_pkg.xx_procedure(:2); end;");
try
{
// Register return variables
((OracleCallableStatement)cs.registerOutParameter(1, Types.VARCHAR, 0, 2000);

// Bind the input parameters
cs.setString(1, "gyan");
// Assign returned values to variables
outParamValue = cs.getString(1);
cs.execute();
cs.close();
}
catch (SQLException sqle){
cs.close();
}