Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORDERED_PREDICATES: puzzling enigma here

Re: ORDERED_PREDICATES: puzzling enigma here

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 11 May 2005 05:51:29 -0700
Message-ID: <1115815889.087720.151130@f14g2000cwb.googlegroups.com> 





The invalid number error is because of the implicit conversion of the
zip varchar2 column to numeric data because you requested Oracle to
compare a character column to a number via "zip = 43933" when you
should have coded "zip = '43933' "



Never rely on implicit conversion by Oracle; always specify the
direction of conversions explicitily using to_number, to_char, to_date,
etc... as the case may be.



HTH -- Mark D Powell --
Received on Wed May 11 2005 - 07:51:29 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US