调用oracle存储过程输入参数后报错
调用oracle存储过程在pl/sql中测试没有问题,但是通过fineReport调用存储过程,输入参数后报literal does not match format string(即字符串格式不匹配)这是怎么回事了??
附日志:
SEVERE:Query:{call CC.CAPITAL_BUDGET('总公司本部人力资源部,总公司本部财务(会计)部','经营期','周转材料-办公家俱,周转材料-办公设备','2012-01-01','2012-03-08',?)}
ORA-01861: literal does not match format string
ORA-06512: at line 1
at com.fr.report.core.A.P.A(Unknown Source)
at com.fr.report.core.A.P.access$4500(Unknown Source)
at com.fr.report.core.A.P$_d.A(Unknown Source)
at com.fr.report.core.A.P.A(Unknown Source)
at com.fr.report.core.A.P.B(Unknown Source)
at com.fr.report.core.A.P.A(Unknown Source)
at com.fr.report.core.A.M.A(Unknown Source)
at com.fr.report.core.A.H.C(Unknown Source)
at com.fr.report.core.A.M.E(Unknown Source)
at com.fr.report.core.A.M.H(Unknown Source)
at com.fr.report.WorkBook.execute(Unknown Source)
at com.fr.log.LogUtils.executeAndLogRecord(Unknown Source)
at com.fr.web.cache.ReportCache.getResultWorkBook(Unknown Source)
at com.fr.web.cache.WorkBookTemplateDelegate.execute(Unknown Source)
at com.fr.web.core.ShowWorkBookPolicy$Policy4Page.show(Unknown Source)
at com.fr.web.core.ReportSessionIDInfor.initBook2Show(Unknown Source)
at com.fr.web.core.ReportSessionIDInfor.getWorkBook2Show(Unknown Source)
at com.fr.web.core.ReportSessionIDInfor.createPageSetChain(Unknown Source)
at com.fr.web.core.ReportSessionIDInfor.getReportPage(Unknown Source)
at com.fr.web.core.A.z$_A.A(Unknown Source)
at com.fr.web.core.A.z$_A.A(Unknown Source)
at com.fr.web.core.A.z.process(Unknown Source)
at com.fr.web.core.ReportDispatcher.dealWithRequest(Unknown Source)
at com.fr.web.ReportServlet.doGet(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:596)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:428)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:473)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:568)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1530)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:633)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1482)
at org.mortbay.http.HttpServer.service(HttpServer.java:909)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:820)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:986)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:837)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:245)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:357)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:534)
有碰到这个情况的如何解决了。