Re: data retrieving

From: <afilonov_at_pro-ns.net>
Date: Tue, 16 Mar 1999 01:57:46 GMT
Message-ID: <7ckdql$q0$1@nnrp1.dejanews.com>

What are 'CL' and 'BD'?
Anyway, Oracle can return error if expression in WHERE clause incorrect for one of the records in the table. It usually happens when implicit conversion needed to compare different data types. Example:

d1 is a date type column in table t1

where t1.d1 < to_date('30-' || to_date(t1.d1, 'MON-YY'), 'DD-MON-RR')

will work if you don't have February dates in d1. For February it'll return an error. Sometimes even if other conditions exclude February dates from query.

In article <7chrt7$oll$1_at_nnrp1.dejanews.com>, hpcheong_at_ncs.com.sg wrote:
> hi all,
>
> One funny problem arises while testing in ncst. I tried to retrieve 'CL'
> records from a table with date as one of the comparsion criteria. It returns
> an error even though records exists. Then I tried with another record 'BD'
> with the same sql and it works.
>
> This was strange as it happen to a specific record type - 'CL'.
>
> pls help....
>
> thanks!
> evelyn.
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 15 1999 - 19:57:46 CST