Skip to content

Usage of Oracle features

The Oracle database SQL and PL/SQL languages has a lot of features. Not all of them are suitable to use withing IFS Applications production code. There hints supply with markers for those features that should be avoided.

Oracle Enterprise Edition feature

These features are not available in Standard Edition and will not deploy correctly at a customer site.

Available actions

  • RemoveStatement

Invalid declaration type

These types should not be used.

Available actions

  • ReplaceStatement

Using a reserved SQL word as procedure/function name.

These names should not be used.

Appendix 1: List of PL/SQL types that should be avoided.

  • VARCHAR
  • CHAR
  • NVARCHAR2
  • NCHAR
  • LONG
  • LONG RAW

Appendix 2: List of PL/SQL procedure and function names that should be avoided.

  • SELECT
  • INSERT
  • UPDATE
  • DELETE

Appendix 3: List of PL/SQL package names that are Enterprise Edition features.

  • DBMS_ADDM
  • DBMS_ADVISOR
  • DBMS_AMD
  • DBMS_AW
  • DBMS_AW_EXP
  • DBMS_AW_LIB
  • DBMS_AW_STATS
  • DBMS_AW_XML
  • DBMS_CRYPTO
  • DBMS_CUBE
  • DBMS_CUBE_ADVICE
  • DBMS_CUBE_ADVICE_SEC
  • DBMS_CUBE_EXP
  • DBMS_CUBE_UTIL
  • DBMS_CUBE_UTIL_DFLT_MSR_R
  • DBMS_CUBE_UTIL_DFLT_MSR_T
  • DBMS_CUBE_UTIL_EXT_MD_R
  • DBMS_CUBE_UTIL_EXT_MD_T
  • DBMS_DUMA_INTERNAL
  • DBMS_DUMA_SYS
  • DBMS_REDEFINITION
  • DBMS_RLS
  • DBMS_SQLPA
  • DBMS_SQLTUNE
  • DBMS_WORKLOAD_CAPTURE
  • DBMS_WORKLOAD_REPLAY
  • DBMS_WORKLOAD_REPOSITORY
  • DBMS_XS_SECCLASS_INT
  • DVSYS
  • SA_LABEL_ADMIN
  • SDO_CSW_PROCESS
  • SDO_GEOM
  • SDO_WFS_LOC
  • SDO_WFS_PROCESS