|
Feature |
Description |
| Oracle
Objects that have other objects as components prior to JDBCWizard V6. |
OrindBuild prior to version 6 could not write code to support procedures and functions that have parameters that are Oracle objects that have other Objects as components. JDBCWizard supports oracle TYPE's that are composed of scaler variables but not ones that include one or more TYPES within them. |
| Oracle
object references. |
JDBCWizard
does not support procedures and functions that have Oracle
object references (e.g. REF) as parameters. |
| Nested
tables |
JDBCWizard
does not yet support procedures and functions that have nested tables
as parameters. |
| PL/SQL
"index by" tables prior to Oracle 10.1.0 |
JDBCWizard
supports procedures and functions that have PL/SQL
"index by" tables as parameters from Oracle V10.1.0/JDBCWizard
V4.0.1818 onwards. See the Manual entry for details. |
| Multi-level
collections prior to JDBCWizard V6 |
JDBCWizard
could not handle PL/SQL records that have one or more
fields that is another record unless the parent record is an ARRAY or
VARRAY. |
VARRAYS and ARRAYS can not have BLOB, CLOB or BFILEs, either by
themselves or as part of oracle TYPE objects
| Domain | PL/SQL Data Type | Comment | JDBCWizard and Oracle version information |
| Numeric | BINARY_INTEGER | Signed
integers with a magnitude range of -2**31 -> 2**31 |
All |
| DEC | Fixed-point decimal with a maximum precision of 38 decimal digits. | All | |
| DECIMAL | Fixed-point decimal with a maximum precision of 38 decimal digits. | All | |
| DOUBLE PRECISION | Floating-point numbers with a maximum precision of 126 binary digits | All | |
| FLOAT | Floating-point numbers with a maximum precision of 126 binary digits | All | |
| INT | Integers with a maximum precision of 38 decimal digits | All | |
| INTEGER | Integers with a maximum precision of 38 decimal digits | All | |
| NATURAL | Positive
Integer 0 --> 2**31 |
All | |
| NATURALN | Positive
Integer 0 --> 2**31; Can not be NULL |
All | |
| NUMBER | 1E-130
--> 10E125 |
All | |
| NUMERIC | Fixed-point decimal with a maximum precision of 38 decimal digits. | All | |
| PLS_INTEGER | Signed
integers with a magnitude range of -2**31 -> 2**31 |
All | |
| POSITIVE | Positive
Integer 1 --> 2**31 |
All | |
| POSITIVEN | Positive
Integer 1 --> 2**31; Can not be NULL |
All | |
| REAL | Floating-point numbers with a maximum precision of 63 binary digits | All | |
| SIGNTYPE | -1, 0 or 1 | All | |
| SMALLINT | Integers with a maximum precision of 38 decimal digits | All | |
| Text | CHAR | Fixed length String up to 32767 bytes in PL/SQL and 2000 bytes in a Table. | All |
| CHARACTER | Fixed length String up to 32767 bytes in PL/SQL and 2000 bytes in a Table. | All | |
| LONG | Variable length string up to 32760 bytes in PL/SQL and 2**31 bytes in a database table | All | |
| STRING | Variable length string up to 32760 bytes in PL/SQL and 4000 bytes in a Table. | All | |
| VARCHAR | Variable length string up to 32760 bytes in PL/SQL and 4000 bytes in a Table. | All | |
| VARCHAR2 | Variable length string up to 32760 bytes in PL/SQL and 4000 bytes in a Table. | All | |
| Binary | LONG RAW | Variable length string up to 32760 bytes in PL/SQL and 2**31 bytes in a database table | All |
| RAW | Fixed length String up to 32767 bytes in PL/SQL and 2000 bytes in a Table. | All | |
| ROWID | Storage address of a row. | All | |
| UROWID | Logical address of a row. | Not supported in JDBC as of 9.2.0 | |
| Large Objects | BFILE | Pointer to operating system file. | JDBCWizard generated code works from Oracle 8.1.7 onwards |
| BLOB | Large Binary Object up to 4GB in size | JDBCWizard generated code works from Oracle 8.1.7 onwards | |
| CLOB | Large Character Object up to 4GB in size | JDBCWizard generated code works from Oracle 8.1.7 onwards | |
| Boolean | BOOLEAN |
TRUE, FALSE, and NULL. |
JDBCWizard 2.0.1098 onwards |
| Date | DATE | Time to within 1 second from January 1, 4712 BC to December 31, 9999 AD | All |
| TIMESTAMP | Extension of DATE with up to 9 decimal places for storing sub-second times. | Oracle 9.0.1 Onwards | |
| TIMESTAMP WITH LOCAL TIME ZONE | Extension of Timestamp that includes a displacement from GMT in hours and minutes. | Oracle 9.0.1 Onwards | |
| TIMESTAMP WITH TIME ZONE | Extension of Timestamp that includes a relative displacement from GMT in hours and minutes. | Oracle 9.0.1 Onwards | |
| INTERVAL YEAR MONTH |
Intervals of years and months | Oracle 9.2.0 Onwards |
|
| INTERVAL DAY SECOND |
Intervals of days, hours, minutes, and seconds | Oracle 10.1.0 Onwards |
|
| Records | %ROWTYPE | Record based on Table or Cursor. | Oracle 8.1.7 Onwards |
| PL/SQL Package Records | With Scalar components, | Oracle 8.1.7 Onwards | |
| CURSORS | Only For OUT parameters | All | |
| Oracle TYPE Objects | With Scalar components only - no TYPE's containing other TYPE's. | Oracle 8.1.7 Onwards |
|
Oracle
Database Version |
Oracle
JDBC Driver Version |
| Oracle
Database Version 8.1.5 |
Oracle 8.1.7 JDBC Driver |
| Oracle
Database Version 8.1.6 |
Oracle
8.1.7 JDBC Driver |
| Oracle
Database Version 8.1.7 |
Oracle
8.1.7 JDBC Driver |
| Oracle
Database Version 9.0.1 |
Oracle
9.0.1 JDBC Driver |
| Oracle
Database Version 9.2.0 |
Oracle
9.2.0 JDBC Driver |
| Oracle Database Version 10.1.0 | Oracle 9.2.0 JDBC Driver or Oracle 10.1.0 JDBC Driver |
| Oracle Database Version 10.2.0 | classes12_1020.jar when working with JVMs up to 1.4; ojdbc14.jar when working with JVMs 1.5 and above. |
| Oracle Database Version 11.1.0 | classes12_1020.jar when working with JVMs up to 1.4; ojdbc14.jar when working with JVMs 1.5 and above. |