• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

help:java.sql.SQLException: ORA-06550

 
elli dian
Greenhorn
Posts: 15
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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:
try
{
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()));
cs.registerOutParameter(2,Types.INTEGER);
cs.execute();
int a=cs.getInt(2);
cs.close();
System.out.println("Nilai"+a);
}catch(SQLException err)
{
err.printStackTrace();
}catch(Exception er)
{
er.printStackTrace();
}finally
{
System.out.println("finally");
conn.close();
}

please give me asolution to solve it...
 
Shailesh Chandra
Ranch Hand
Posts: 1082
Java Oracle Spring
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator

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'

Shailesh
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic