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