| 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
|
posted

0
|
|
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.
|
 |
 |
|
|
subject: Calling stored procedure
|
|
|