1.1 What’s New

Table of Contents Previous Next


1 Introduction : 1.1 What’s New

The following database compatibility for Oracle features have been added to Advanced Server 9.4 to create Advanced Server 9.5:
Advanced Server now supports the SYS_CONNECT_BY_PATH for hierarchical queries. For more information, see Section 2.2.5.7.
Advanced Server now supports WAIT n syntax in the FOR UPDATE clause of a SQL SELECT statement. For more information, see Section 3.3.65.12.
Advanced Server now supports the DBMS_SESSION.SET_ROLE procedure. For more information, see Section 7.13.1.
Advanced Server now supports the UTL_RAW package. For more information, see Section 7.20.
Advanced Server supports the use of EDBLDR_ENV_STYLE to specify the style of environment variables recognized by EDB*Loader. For more information, see Section 11.2.3.
EDB*Loader now accepts the ZONED [(precision[,scale])] field type specification. For more information, see Section 11.2.3.
Advanced Server now supports the UTL_HTTP.WRITE_LINE and UTL_HTTP.WRITE_TEXT procedures. For more information, see sections 7.18.25 and 7.18.27, respectively.
Advanced Server now supports the DBA_PROFILES view. For more information, see Section 10.36.
Advanced Server now supports the REPLACE clause in the ALTER ROLE and ALTER USER commands. For more information, see sections 3.3.4 and 3.3.10, respectively.
Advanced Server now supports the FREEZE keyword in the EDB*Loader control file and on the command line. For more information, see sections 11.2.3 and 11.2.4, respectively.
Advanced Server now supports the STRICT, LEAKPROOF, COST, ROWS, and SET keywords in the CREATE PROCEDURE and CREATE FUNCTION commands. For more information, see sections 3.3.23 and 3.3.18, respectively.
Advanced Server now supports XA functions xaoEnv and xaoSvcCtx in the Open Client Library. For more information, see Section 9.4.6.
Advanced Server now supports the EDB_ATTR_EMPTY_STRINGS environment attribute in the Open Client Library. For more information, see Section 9.4.2.1.

1 Introduction : 1.1 What’s New

Table of Contents Previous Next