Posts Tagged ‘datatype’

When The Combination of an Oracle Sequence and a PLS_INTEGER is Deadly

The following is a true story. We had our Oracle MRP system down for a couple of days because of a simple, yet hidden bug that went unnoticed for years until it hit us couple of days ago (somehow the image of a terrorist cell comes to mind).

In Oracle Applications (11.03) there is a table […]

One more reason to upgrade your Oracle 8i

On my Oracle database 8i (8.1.7.4) instance, I ran the following:

SQL> SELECT 1 my_number 2 FROM DUAL 3 UNION 4 SELECT NULL my_number 5 FROM DUAL 6 / SELECT 1 my_number * ERROR at line 1: ORA-01790: expression […]