RE: Re: Oracle SQL problem determination
"Simoneau, Roger" <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <85214F3A9C2FE94F9FF1D7C6456E33F9109EA1BB4B@EX-CLUS-MBX-01.abcp.ab.bluecross.ca> |
Excellent place to check. The error most often results (in my experience) when an implicit - as opposed to explicit - data type conversion is involved. From: [email protected] [mailto:[email protected]] On Behalf Of smlivesay Sent: Wednesday, May 30, 2012 3:11 PM To: [email protected] Subject: [toad] Re: Oracle SQL problem determination I have to ask this because I have been burned too many times... Please do a "DESC ps_pay_calendar" and show us that pay_end_dt really is a DATE field and not VARCHAR2 or CHAR. Thanks Mike ________________________________ This communication, including any attached documentation, is intended only for the person or entity to which it is addressed, and may contain confidential, personal and/or privileged information. Any unauthorized disclosure, copying, or taking action on the contents is strictly prohibited. If you have received this message in error, please contact us immediately so we may correct our records. Please then delete or destroy the original transmission and any subsequent reply.