SQL & PL/SQL

Hi All,
When I run this report shows the following error:

ORA-01841: (full) year must be between -4713 and +9999, and not be 0

Plz help me.

Thanks,
AP



Running report /web/knta/rpt/ReportChangeControlCalendar.jsp
Posting report request to http://3.154.0.27:8080/itg/servlet/RunJspReport
Post data = 'REPORT_JSP=/web/knta/rpt/ReportChangeControlCalendar.jsp&OUT_BASEFILE=rep_33629&USER_ID=55603&REPORT_ID=33629&KEYID=37123&KEY=2009214162'
Writing report file /opt/kintana/ITG/reports/rep_33629.html
Error running report.
(Cleaning up any partial report output...)
HTTP response: 500 - org.apache.jasper.JasperException: ORA-01841: (full) year must be between -4713 and +9999, and not be 0


SELECT REQUEST_ID,to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss') P_DEPLOYDATE,
trim(to_char(to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss'),'DAY')) P_DEPLOYDAY,
to_char(to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss'),'hh:mi') START_TIME,
to_char(to_date(P_REQ_END_DATE,'yyyy-mm-dd hh24:mi:ss'),'mm-dd-yyyy hh24:mi') P_REQ_END_DATE,
replace(P_IMPACT_BUSINESS,'#@#',','),P_TITLE,P_CLASSIFICATION,P_REQUESTED_BY,
replace(p_pole,'#@#',','), to_date(P_REQ_END_DATE,'yyyy-mm-dd hh24:mi:ss')
FROM KINTANA.MREQ_TSO_CHANGE_REQUEST
where
to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss') >= to_date('2006-04-24 00:00:00','yyyy-mm-dd hh24:mi:ss')
and to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss') <= to_date('2006-04-24 00:00:00','yyyy-mm-dd hh24:mi:ss')+7
and P_POLE like '%Europe%'
order by 2,11

org.apache.jasper.JasperException: ORA-01841: (full) year must be between -4713 and +9999, and not be 0


SELECT REQUEST_ID,to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss') P_DEPLOYDATE,
trim(to_char(to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss'),'DAY')) P_DEPLOYDAY,
to_char(to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss'),'hh:mi') START_TIME,
to_char(to_date(P_REQ_END_DATE,'yyyy-mm-dd hh24:mi:ss'),'mm-dd-yyyy hh24:mi') P_REQ_END_DATE,
replace(P_IMPACT_BUSINESS,'#@#',','),P_TITLE,P_CLASSIFICATION,P_REQUESTED_BY,
replace(p_pole,'#@#',','), to_date(P_REQ_END_DATE,'yyyy-mm-dd hh24:mi:ss')
FROM KINTANA.MREQ_TSO_CHANGE_REQUEST
where
to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss') >= to_date('2006-04-24 00:00:00','yyyy-mm-dd hh24:mi:ss')
and to_date(P_DEPLOYDATE,'yyyy-mm-dd hh24:mi:ss') <= to_date('2006-04-24 00:00:00','yyyy-mm-dd hh24:mi:ss')+7
and P_POLE like '%Europe%'
order by 2,11

at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:254)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:241)
at javax.servlet.http.HttpServlet.service(Unknown Source)
at org.mortbay.jetty.servlet.ServletHolder.handle(Unknown Source)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(Unknown Source)
at org.mortbay.jetty.servlet.Dispatcher.dispatch(Dispatcher.java:192)
at org.mortbay.jetty.servlet.Dispatcher.forward(Dispatcher.java:129)
at com.kintana.rpt.web.servlet.RunJspReport.doPost(RunJspReport.java:73)
at javax.servlet.http.HttpServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(Unknown Source)
at org.mortbay.jetty.servlet.ServletHolder.handle(Unknown Source)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(Unknown Source)
at com.kintana.core.web.filter.ControlFilter.doFilter(ControlFilter.java:627)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(Unknown Source)
at com.kintana.core.web.filter.MultipartRequestFilter.doFilter(MultipartRequestFilter.java:77)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(Unknown Source)
at com.kintana.core.web.filter.I18nFilter.doFilter(I18nFilter.java:45)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(Unknown Source)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(Unknown Source)
at org.mortbay.jetty.servlet.ServletHandler.handle(Unknown Source)
at org.mortbay.http.HttpContext.handle(Unknown Source)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(Unknown Source)
at org.mortbay.http.HttpContext.handle(Unknown Source)
at org.mortbay.http.HttpServer.service(Unknown Source)
at org.jboss.jetty.Jetty.service(Unknown Source)
at org.mortbay.http.HttpConnection.service(Unknown Source)
at org.mortbay.http.HttpConnection.handleNext(Unknown Source)
at org.mortbay.http.HttpConnection.handle(Unknown Source)
at org.mortbay.http.SocketListener.handleConnection(Unknown Source)
at org.mortbay.util.ThreadedServer.handle(Unknown Source)
at org.mortbay.util.ThreadPool$PoolThread.run(Unknown Source)