.
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
.
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
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
is always 0. And when I start to
load the file, I receive this error (I'm testing with a few random
records from the 2200+ and each have the same error):
Record 1: Rejected - Error on table LC_F, column MODCNT.
ORA-01722: invalid number
Any help is greatly appreciated. Thanks,
Saira
--
Please see
Subject:ORA-01722 Error after DBA changes
I have been getting a FRM-40735 WHEN-BUTTON-PRESSED trigger raised
unhandled exception ORA-01722 error. The button calls a procedure in
the form. Whenever this happens, I open up the form in Developer,
recompile it, generate a new .fmx file
Hi List,
I have a strange problem for ONLY one table in entire database, when run the
following query got ORA - 01722 and when I drop the table and rebuild it
it's running OK,
Any Idea?
this is the query which I run:
select count(*)
from (select osi_srv_code_from, osi_srv_code_to
Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
-Original Message-
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: 21 April 2002 19:59
|Hi List,
|I have a strange problem for ONLY one table in entire database, when
run the
|following query got ORA - 01722