-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
last post
Wolfgang Breitling wrote:
| My guess would be that company is not a number but because you do | compare it to a number "company=2000" Oracle does an implicit | conversion "to_number(company)=2000" and that fails when it hits a | row where company is not numeric. | If my guess is right try company='2000' | | At 07:59 PM 1/30/2004, you wrote: | |> I am running a query: |> select.... |> from.... |> WHERE COMPANY=2000 AND |> LOCATION='CDJ01' AND ITEMLOC.ACTIVE_STATUS='A' AND |> POVAGRMTLN.PROCURE_GROUP='SMAR' |> AND RTRIM(LTRIM(POVAGRMTLN.VEN_AGRMT_REF)) = 'COM1-21-LARROC NANCY' |> AND RTRIM(LTRIM(POVAGRMTLN.VENDOR))='21' |> |> and in the next part of the where I got this error:ORA-01722 |> invalid number |> |> AND RTRIM(LTRIM(POVAGRMTLN.VEN_AGRMT_REF)) = 'COM1-21-LARROC NANCY' |> |> If I write 'COM-21-LARROC NANCY' the error dissapear, I don't have |> any clue why this happen, I read about this error but the help |> don't seem to fit on this case. |> The POVAGRMTLN.VEN_AGRMT_REF field is char(30). |> |> ORA-01722 invalid number |> |> Cause: The attempted conversion of a character string to a number |> failed because the character string was not a valid numeric |> literal. Only numeric fields or character fields containing numeric |> data may be used in arithmetic functions or expressions. Only |> numeric fields may be added to or subtracted from dates. |> |> Action: Check the character strings in the function or expression. |> Check that they contain only numbers, a sign, a decimal point, and |> the character "E" or "e" and retry the operation. | | | Wolfgang Breitling | Oracle7, 8, 8i, 9i OCP DBA | Centrex Consulting Corporation | http://www.centrexcc.com
- -- Joseph S Testa Chief Technology Officer Data Management Consulting 614-791-9000 It's all about the "CACHE" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFAGyRxR8fSap71V7YRApzzAKCoA6lzRXR7hCWkZmSA0RW+DXvg/QCeNQPK WQEp4pYfX7j7JxYW8RMbeN8= =kTiZ -----END PGP SIGNATURE-----
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
