FreeLists / oracle-l / RE: data type conversion in 10g

["Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>]

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Boyd
Sent: Tuesday, July 03, 2007 12:43 PM
To: oracle-l@xxxxxxxxxxxxx
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.

==============================================================================