I have an issue that is generated randomly (one time between thousandth of calls). The error ORA-01722: invalid number is generated in a random way while executing sql update in a prepared statemen...

SELECT TO_NUMBER('*') FROM DUAL This obviously gives me an exception: ORA-01722: invalid number Is there a way to "skip" it and get 0 or NULL instead? The whole issue: I have NVARCHAR2 fiel...

Why the heck does Oracle offer a different(!) version of the JDBC driver, e.g. ojdbc14.jar, for every(!) database version? The files all have different sizes and thus probably different content. b...

I've been using a parameterized query to insert values into an Oracle table, like so: var q = "insert into MyTable(Field1, Field2...) values(:Field1, :Field2...)"; var cmd = new OracleCommand(q, c...

I have a table Application which has a column BORROWINGTERM NUMBER(10,0) Nullable why this script throw an error (ORA-01722 invalid number) select nvl(borrowingterm, 'no term') from Application...

This is an absolute howler. I cannot believe my own eyes, and I cannot believe nobody before me would have discovered this if it was a genuine bug in C#, so I'm putting it out for the rest of the d...

How can I create a Sequence where my START WITH value comes from a query? I'm trying this way: CREATE SEQUENCE "Seq" INCREMENT BY 1 START WITH (SELECT MAX("ID") FROM "Table"); But, I get the OR...

I have an Oracle table and a column (col1) has type varchar2(12 byte). It has one row and value of col1 is 1234 When I say select * from table where col1 = 1234 Oracle says invalid number. Why...

I have a problem when inserting a string of numbers into sql query SELECT * FROM tablename a WHERE a.flokkurid IN (3857,3858,3863,3285) ORDER BY sjodategund, rodun ...or: SELECT * FRO...

First of all I am using Oracle: Table One Name = tableone Table Two Name = tabletwo tableone has a column named pizzaone, tabletwo has a column named pizzatwo. I want to join tableone to tabletw...

I try to insert into table with sequence .nextval as primary key, the sql in Java is sql = "INSERT INTO USER (USER_PK, ACCOUNTNUMBER, FIRSTNAME, LASTNAME, EMAIL ) VALUES (?,?,?,?,?)"; ps =...

I have a query that joins two tables. One table has a column that is of type varchar, and the other table has type of number. I have executed my query on 3 oracle databases, and am seeing some stra...

I want to write a funcion or procedure that can be used in the IN clause of another procedure. The function or procedure would return ID numbers. The main procedure would say something like SEL...