This week's book giveaway is in the Cloud forum.
We're giving away four copies of The Business Blockchain and have William Mougayar on-line!
See this thread for details.
Win a copy of The Business Blockchain this week in the Cloud forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Calling stored procedure

 
elli dian
Greenhorn
Posts: 15
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I am callin stored procedure, but I get error:
java.sql.SQLException: ORA-20110: TimePersDiary.NOAUTHCREATE
Give me a solution to solve it.Thank you!!

My program:
String fdate=request.getParameter(Absen_DexaPortlet.FDATE);
String tdate=request.getParameter(Absen_DexaPortlet.TDATE);
String reason=request.getParameter(Absen_DexaPortlet.REASON);
submitAbsenceData(fdate,tdate,reason);


public void submitAbsenceData(String fdate, String tdate,String reason)
{

try
{
Connection conn=getConnection();
System.out.println("reason"+reason);
CallableStatement cs=conn.prepareCall("{call IFSAPP.WEBASE_UTIL_API.submitAbsenceData('DX','DX005010001','"+fdate+"','"+tdate+"','"+reason+"')}");
cs.execute();
cs.close();
conn.close();
}catch(SQLException err)
{
err.printStackTrace();
}catch(Exception er)
{
er.printStackTrace();
}
}
 
stu derby
Ranch Hand
Posts: 333
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
ORA-2110 is a user-specified error message; whatever your problem is, it's specific to your use of that package, and not some sort of generic error.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic