Error while trying to call a procedure from JAVA method.
Due to some performance improvement reason, we are trying to call ERP Procedures from Webcenter Portal through JDBC connection.
Please find the below snippet. While trying to call it through Java am getting below error. Can someone please suggest.
String functionCall =
"{call xxk_employee_attendance_pkg.UserAttendanceWSDL(?,?,?,?,?)}";
ResultSet rs = null;
try {
DatabaseConnection database= new DatabaseConnection();
con = database.getDataSource(Constant.ERP_DS_JNDI).getConnection();
if(con !=null){
try {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date d = new Date();
String ourMsg = "";
cs = con.prepareCall(functionCall);
cs.setString(1, "1111111"); //Employee Number
cs.setString(2, d.toString()); //Start Date
cs.setString(3, d.toString()); //End Date
cs.registerOutParameter(4, Types.VARCHAR); //Outputmsg