Does SQLJ implement the ISO SQLJ specification?
Yes, Oracle SQLJ 8.1.7 and later supports the ISO specification. Note that the SQLJ ISO standard requires full support for JDK 1.2 or later. Thus, in order to be fully ISO compliant you would need to use JDK 1.2 or later and translate as well as run your SQLJ program with runtime12.zip (or runtime12ee.zip). Additional features, while recognized by Oracle SQLJ, are not supported by the Oracle JDBC drivers or Oracle database: the path and transformGroup attributes on connection contexts, as well as type map property entries of the kinds JAVA_OBJECT and DISTINCT are not supported presently by Oracle. Furthermore, some minor SQLJ features that were already part of the ANSI standard, while recognized by Oracle SQLJ, are not supported by the Oracle JDBC drivers or Oracle database. These features include the sensitivity, holdability, and returnability constants you can set in a with clause, and positioned UPDATE/DELETE/INSERT operations -see also “Does Oracle SQLJ support the WHERE CURRENT OF
