Debugging runtime pl/sql errors

Question

I’m new in pl/sq.

So, I’m trying to call pl/sql stored procedure from Java, but appears error:

wrong number or types of arguments in call to ‘searchuser’.

Where can I find most specific exception?

Is there some error logs or errors table in oracle? How can I debug these kind of problems?

Thanks!

PT_STAR · Accepted Answer · 2014-12-08 15:46:03Z

1

one thing is if you call stored procedures from java: don't forget to register the function result. Example Java code:

        CallableStatement cstmt = connection.prepareCall("{? = call xxx.checkArea(?,?)}");

        // the 1st Parameter is the result of the function checkArea
        cstmt.registerOutParameter(1, Types.INTEGER);   // Function Return
        cstmt.setInt(2, status);                        // Parameter 1 (in)
        cstmt.registerOutParameter(3, Types.INTEGER);   // Parameter 2 (out)

        // execute the call
        cstmt.execute();

        // check the results
        sessionId = cstmt.getInt(1); // Session-ID
        rows = cstmt.getInt(3);      // Rows

The PL/SQL Function is declared as following:

  function checkArea(pi_area     in  number,
                     po_rows     out number) return number;

answered Dec 8, 2014 at 15:46

PT_STAR

5051 gold badge5 silver badges13 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Debugging runtime pl/sql errors

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related