Top "Ora-01722" questions

PL SQL : NVL first parameter type conversion issue

I have a table Application which has a column BORROWINGTERM NUMBER(10,0) Nullable why this script throw an error (ORA-01722 invalid …

sql oracle ora-01722

Why am I getting an ORA-01722 (invalid number)?

I've been using a parameterized query to insert values into an Oracle table, like so: var q = "insert into MyTable(…

c# oracle ora-01722

ORA-01722: invalid number for a simple query

I noticed the same topics here but I just couldn't find the answer because of my noob skill in databases, …

oracle numbers varchar ora-01722

problem using Oracle parameters in SELECT IN

I have a problem when inserting a string of numbers into sql query SELECT * FROM tablename a WHERE a.flokkurid …

c# sql oracle parameters ora-01722

Getting weird issue with TO_NUMBER function in Oracle

I have been getting an intermittent issue when executing to_number function in the where clause on a varchar2 column …

sql oracle oracle10g ora-01722

ERROR java.sql.SQLException: ORA-01722: invalid number while running a Prepared Statement to alter a Sequence

sqlStmt = new StringBuffer(" ALTER SEQUENCE " ); sqlStmt.append( ServerContext.getSchemaName() ); sqlStmt.append("SEQ_EDCD_TRACE_NUM"); sqlStmt.append( " INCREMENT BY " ); sqlStmt.…

java oracle jdbc prepared-statement ora-01722

Problem with Oracle Sql Loader control file

I'm trying to load some data using sql loader. Here is the top of my control/data file: LOAD DATA …

oracle sql-loader ora-01722

Invalid Number Error! Can't seem to get around it

Oracle 10g DB. I have a table called s_contact. This table has a field called person_uid. This person_…

sql oracle oracle10g ora-01722