Top "Ora-01722" questions

"Safe" TO_NUMBER()

SELECT TO_NUMBER('*') FROM DUAL This obviously gives me an exception: ORA-01722: invalid number Is there a way …

oracle type-conversion ora-01722

I can't understand the reason behind ORA-01722: invalid number

I have an issue that is generated randomly (one time between thousandth of calls). The error ORA-01722: invalid number is …

java oracle jdbc prepared-statement ora-01722

Joining tables with LIKE (SQL)

First of all I am using Oracle: Table One Name = tableone Table Two Name = tabletwo tableone has a column named …

sql oracle ora-01722

Oracle number and varchar join

I have a query that joins two tables. One table has a column that is of type varchar, and the …

performance oracle join to-char ora-01722

Create a Sequence with START WITH from Query

How can I create a Sequence where my START WITH value comes from a query? I'm trying this way: CREATE …

oracle plsql sequence oracle9i ora-01722

.nextval JDBC insert problem

I try to insert into table with sequence .nextval as primary key, the sql in Java is sql = "INSERT INTO …

java sql oracle jdbc ora-01722

oracle jdbc driver version madness

Why the heck does Oracle offer a different(!) version of the JDBC driver, e.g. ojdbc14.jar, for every(!) database …

java sql oracle jdbc ora-01722

sqlplus - using a bind variable in "IN" clause

I am setting a bind variable in a PL/SQL block, and I'm trying to use it in another query's …

oracle oracle10g sqlplus ora-01722 bind-variables

Can I pass a number for varchar2 in Oracle?

I have an Oracle table and a column (col1) has type varchar2(12 byte). It has one row and value of …

sql oracle ora-01722

C# parameterized queries for Oracle - serious & dangerous bug!

This is an absolute howler. I cannot believe my own eyes, and I cannot believe nobody before me would have …

c# oracle ora-01722