File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes help:java.sql.SQLException: ORA-06550 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of REST with Spring (video course) this week in the Spring forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "help:java.sql.SQLException: ORA-06550" Watch "help:java.sql.SQLException: ORA-06550" New topic

help:java.sql.SQLException: ORA-06550

elli dian

Joined: May 18, 2006
Posts: 15
I have a stored procedure.
The name of stored procedure is isClockingProblem(company,emp,clockingdate) return number.
0=ok,1=no clocking, 2=no out data.
So i want to call the stored procedure, but i get error:
SystemErr R java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'ISCLOCKINGPROBLEM'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

my code:
System.out.println("Calling a procedure");
CallableStatement cs=conn.prepareCall("{call IFSAPP.WEBASE_UTIL_API.isClockingProblem('DX','DX005010001',?,?)}");
cs.setTimestamp(1,new Timestamp(new java.util.Date().getTime()));
int a=cs.getInt(2);
}catch(SQLException err)
}catch(Exception er)

please give me asolution to solve it...
Shailesh Chandra
Ranch Hand

Joined: Aug 13, 2004
Posts: 1082

This is your stored procedure as you say, which takes 3 areguemnt as inputs and returns on output number

isClockingProblem(company,emp,clockingdate) return number

This is how you are calling your stored procedure and passing 4 arguemnts.

CallableStatement cs=conn.prepareCall("{call IFSAPP.WEBASE_UTIL_API.isClockingProblem('DX','DX005010001',?,?)}");

Now you can understand why are you getting the error
PLS-00306: wrong number or types of arguments in call to 'ISCLOCKINGPROBLEM'


Gravitation cannot be held responsible for people falling in love ~ Albert Einstein
I agree. Here's the link:
subject: help:java.sql.SQLException: ORA-06550
It's not a secret anymore!