Oracle JDBC Limitations

The current implementation of Oracle JDBC has several limitations:

  • CursorName is not supported. Oracle JDBC drivers do not support the getCursorName() and setCursorName() methods because there is no easy way to map them to equivalent Oracle constructs. The workaround for this limitation is to use the Oracle ROWID.

  • SQL92 Outer join escapes are not supported. The workaround is to use the Oracle SQL syntax with (+).

  • Calling arguments or return values of the PL/SQL TABLE, BOOLEAN, or RECORD types is not supported.

  • The arithmetic for the Oracle NUMBER type does not comply with the IEEE 754 standard for floating-point arithmetic, and therefore the results of computations performed by Oracle and the same computations performed by ...

Get e-Commerce Applications Using Oracle8i and Java from Scratch now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial