jQuery in Action, 2nd edition
The moose likes JDBC and the fly likes Calling stored procedure Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "Calling stored procedure" Watch "Calling stored procedure" New topic
Author

Calling stored procedure

elli dian
Greenhorn

Joined: May 18, 2006
Posts: 15
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

Joined: Dec 15, 2005
Posts: 333
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.
 
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to run our stuff on 16 servers instead of 3.
 
subject: Calling stored procedure
 
Similar Threads
comparing date
How to handle comma in the text field?
Problem in setting the date in a servlet
Element type "chartLegend" must be declared
how to passing dynamic parameter into jasper report through jsp