Error getting explain plan for cast as DATE
739889Mar 11 2010 — edited Mar 11 2010Sql Developer 2.1.1 win64 on JDK 1.6u18.
When I try to get the explain plan for these queries:
select cast(:a as date) from dual;
select cast(:a as timestamp) from dual;
select cast(:a as timestamp(3)) from dual;
select cast(:a as timestamp(6)) from dual;
select cast(:a as number) from dual;
I get this error:
ORA-25137: Data value out of range.
Any of these don't have that problem:
select cast(:a as number(10)) from dual;
select cast(:a as varchar2(100)) from dual;
Any clue as to why and how to get around it? Especially for the DATE case.