Oracle8i SQLJ Developer's Guide and Reference Release 8.1.5 A64684-01 |
|
The Oracle SQLJ translator accepts a broader range of SQL syntax than the ANSI SQLJ Standard specifies.
The standard addresses only the SQL92 dialect of SQL, but allows extension beyond that. Oracle SQLJ supports Oracle's SQL dialect, which is a superset of SQL92. Therefore, if you must create SQLJ programs that work with other DBMS vendors, you should avoid using SQL syntax and SQL types that are not in the standard and therefore might not be supported in other environments.
Oracle SQLJ supports the following Java types as extensions to the SQLJ standard. Do not use these or other types if you may want to use your code in other environments. To ensure that your application is portable, use the Oracle SQLJ -warn=portable
flag. (See "Translator Warnings (-warn)".)
oracle.sql.*
classes as wrappers for SQL data (see "Oracle Type Extensions")
CustomDatum
interface), typically produced by the Oracle JPublisher utility, to correspond to SQL objects, object references, and collections (see "About Custom Java Classes and the CustomDatum Interface")
AsciiStream
, BinaryStream
, UnicodeStream
) used as output parameters (see "Support for Streams")
For information about the oracle.sql
package, see "Oracle Type Extensions".
For general information about Oracle SQLJ extensions, see Chapter 5, "Type Support", and Chapter 6, "Objects and Collections".