Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORA-01858

ORA-01858

From: <anil4yesu_at_gmail.com>
Date: 28 Feb 2007 13:16:31 -0800
Message-ID: <1172697391.190577.61880@q2g2000cwa.googlegroups.com>

The following SQL works well without the last line, once I add the last line, I get ORA-01858.
I am not sure why it works in the SELECT but not in the WHERE clause.

We have Oracle 9.2.0.7.

select msg, source, msg_type, svr_cd,
to_date(substr(msg,instr(msg,'Eff Dt:') + 8,10), 'mm/dd/yyyy') from hotlist
where fnctn = 'ROUTE'
and source = 'SRF Data'
and (sysdate - 30) > to_date(substr(msg,instr(msg,'Eff Dt:') + 8,10), 'mm/dd/yyyy')

Any suggestions/thoughts are appreciated

Thanks Received on Wed Feb 28 2007 - 15:16:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US