USoft for Oracle
Oracle versions 9 and 10 are currently supported by USoft Developer, in line with the policy that USoft should support the two most recent versions of Oracle.
In principle, Oracle 7.3 and Oracle 8 are also supported by USoft Developer, but since January 2005, they are no longer supported by Oracle. This means that support for USoft in combination with these versions is limited.
For more details of the latest support policy for USoft and Oracle, please contact your local USoft Sales organization.
Supported Data Types
The following data types are supported for Oracle:
Oracle 8 introduced new BLOB/CLOB data types to support large object columns. USoft also supports thesedata types.
CLOB and BLOB data types replace LONG and LONG RAW respectively. In Oracle 7 and earlier, LONG and LONG RAW were used as follows:
The LONG and LONG RAW data types are still supported by USoft and Oracle for backward compatibility, but will eventually disappear.
BLOB/CLOB data types differ from LONG and LONG RAW data types in the following ways:
Unsupported Data Types
Newer features of Oracle, for example, user defined data types, are not supported in USoft .
Universal date_to_char and char_to_date functions are available for Oracle. The syntax is:
SELECT date_to_char(<expression>,<format>) FROM <table>
SELECT char_to_date(<expression>,<format>) FROM <table>
Supported SQL Constants
The following SQL constants are supported for Oracle:
Oracle Optimization Hints
Oracle SQL hints that are used in a SELECT statement are passed through to the RDBMS. An Oracle SQL hint has the following form:
SELECT /*+ <hint> */ ...
Where <hint> is a hint for the Oracle RDBMS. Refer to your Oracle documentation for details.
The Rules Engine does not interpret these comments. Take in mind that the Rules Engine can change SQL statements for optimization reasons. When making these changes, the Oracle SQL hints are not taken into consideration. Therefore, the hints may not fit the resulting SQL statement.
The "orawarnings.ust" file in USoft's \app folder (app-defaults directory on UNIX) contains error messages that are to be ignored, and warning messages that are to be displayed.
Character Set Conversion
When the character set on the client is different from the database server, for example when the client uses WE8ISO8859P1 and the server uses WE8MSWIN1252, Oracle performs a character set conversion. Characters that do not exist in one of the sets will be converted to a ¿ (ASCII value 191) in the database. This might be the case for the Euro sign (ASCII value 128) and several other characters.
You can overrule a client character setting by using the environmentSet resource. To set the client character set to WE8MSWIN1252 add the following resource setting to the Application Properties in the USoft Binder:
This resource setting can be used to change any environment setting for the client. The syntax is: