Portals (MOSC)

MOSC Banner

Error while trying to call a procedure from JAVA method.

edited Nov 12, 2015 10:05AM in Portals (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center