Hey guys
I am running jsp scripts using Tomcat 5.5 and Oracle8i.
I am getting an error while running an insert statement
error is "javax.servlet.ServletException: ORA-01843: not a valid month"
Now this is occuring on the date field. Please note that I am simply inserting hardcoded dates in the format of "01-JAN-2005". I believe this is the default format for oracle. Why isnt this working???
Here is the complete sql statement
String insertQuery = "INSERT INTO JOB_REQUISITION("
+ "JBR_DEPT_TBLGRPCD, "
+ "JBR_UNITNO, "
+ "JBR_SEQ_NBR, "
+ "JBR_REQUEST_ID, "
+ "JBR_REQUEST_DT, "
+ "JBR_STS_CD, "
+ "JBR_STS_DT, "
+ "JBR_JOB_ORG_ID, "
+ "JBR_JOB_TBLGRPCD, "
+ "JBR_JOB_CLASS, "
+ "JBR_LST_UPDT_IP_ADDR, "
+ "JBR_LST_UPDT_ID, "
+ "JBR_LST_UPDT_TS) VALUES('"
+ dptGrpCode + "', '"
+ department + "', "
+ nextJobReqNum + ", '"
+ ofcLogin.getEscUser() + "', '01-JAN-2005', 'OP', '01-JAN-2005', '"
+ organization + "', '"
+ jobGrpCode + "', '', '"
+ remoteIp + "', '"
+ ofcLogin.getEscUser() + "', '01-JAN-2005' )";
dbc.executeUIDQuery(insertQuery);
I would appreciate any help.
Thanks
I am running jsp scripts using Tomcat 5.5 and Oracle8i.
I am getting an error while running an insert statement
error is "javax.servlet.ServletException: ORA-01843: not a valid month"
Now this is occuring on the date field. Please note that I am simply inserting hardcoded dates in the format of "01-JAN-2005". I believe this is the default format for oracle. Why isnt this working???
Here is the complete sql statement
String insertQuery = "INSERT INTO JOB_REQUISITION("
+ "JBR_DEPT_TBLGRPCD, "
+ "JBR_UNITNO, "
+ "JBR_SEQ_NBR, "
+ "JBR_REQUEST_ID, "
+ "JBR_REQUEST_DT, "
+ "JBR_STS_CD, "
+ "JBR_STS_DT, "
+ "JBR_JOB_ORG_ID, "
+ "JBR_JOB_TBLGRPCD, "
+ "JBR_JOB_CLASS, "
+ "JBR_LST_UPDT_IP_ADDR, "
+ "JBR_LST_UPDT_ID, "
+ "JBR_LST_UPDT_TS) VALUES('"
+ dptGrpCode + "', '"
+ department + "', "
+ nextJobReqNum + ", '"
+ ofcLogin.getEscUser() + "', '01-JAN-2005', 'OP', '01-JAN-2005', '"
+ organization + "', '"
+ jobGrpCode + "', '', '"
+ remoteIp + "', '"
+ ofcLogin.getEscUser() + "', '01-JAN-2005' )";
dbc.executeUIDQuery(insertQuery);
I would appreciate any help.
Thanks