RE: data type conversion in 10g

From: Kerber, Andrew W. <Andrew.Kerber_at_umb.com>
Date: Tue, 3 Jul 2007 13:00:21 -0500
Message-ID: <D40740337A3B524FA81DB598D2D7EBB3097A8642@x6009a.umb.corp.umb.com>

You were right on your assumption. Oracle 10g will not allow many of the poor practices that people have gotten away with in the past. I suspect its related to the CBO, but I don't know that for sure.  

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of David Boyd Sent: Tuesday, July 03, 2007 12:43 PM
To: oracle-l_at_freelists.org
Subject: data type conversion in 10g    

We have Oracle 10.2.0.3. There is one field, test1 that is definite as char(2). When we use 'where test1<88', it works fine in 9i, but we get 'ORA-01722 invalid number' error in 10g. Once I add single quotes around 88, the error is gone. I know the best practice is not to use implicit conversion. Just wonder why it works in 9i, but not in 10g, more restriction in 10g or if there is any change in 10g that causes the error tracked?  

---

See what you're getting into...before you go there. Check it out! <http://newlivehotmail.com>

---

NOTICE: This electronic mail message and any attached files are confidential. The information is exclusively for the use of the individual or entity intended as the recipient. If you are not the intended recipient, any use, copying, printing, reviewing, retention, disclosure, distribution or forwarding of the message or any attached file is not authorized and is strictly prohibited. If you have received this electronic mail message in error, please advise the sender by reply electronic mail immediately and permanently delete the original transmission, any attachments and any copies of this message from your computer system. Thank you.

---

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Jul 03 2007 - 13:00:21 CDT