While creating or upgrading the Spotlight database user the following error occurs:
ORA-06550: line 12, column 11:
PLS-00905: object SYS.BUILD_XVIEW is invalid
ORA-06550: line 12, column 7:
PL/SQL: Statement ignored
ORA-06550: line 16, column 8:
PLS-00905: object SYS.BUILD_XVIEW is invalid
ORA-06550: line 16, column 4:
PL/SQL: Statement ignored
ORA-06550: line 18, column 8:
PLS-00905: object SYS.BUILD_XVIEW is invalid
ORA-06550: line 18, column 4:
PL/SQL: Statement ignored
ORA-06550: line 19, column 8:
PLS-00905: object SYS.BUILD_XVIEW is invalid
ORA-06550: line 19, column 4:
PL/SQL: Statement ignored
ORA-06550: line 20, column 8:
PLS-00905: object SYS.BUILD_XVIEW is invalid
ORA-06550: line 20, column 4:
PL/SQL: Statement ignored
ORA-06550: line 21, column 8:
PLS-00905: object SYS.BUILD_XVIEW is invalid
ORA-06550: line 21, column 4:
PL/SQL: Statement ignored
ORA-06550: line 22, column 8:
PLS-00905: object SYS.BUILD_XVIEW is invalid
ORA-06550: line 22, column 4:
PL/SQL: Statement ignored
ORA-06550: line 23, column 8:
PLS-00905: object SYS.BUILD_XVIEW is invalid
ORA-06550: line 23, column 4:
in table MakeXviews
The Oracle parameter PLSQL_CODE_TYPE is set to NATIVE.
Set the Oracle parameter PLSQL_CODE_TYPE to INTERPRETED.
INTERPRETED is the default value.
Use the Oracle command ALTER SYSTEM or ALTER SESSION to change the parameter.
PLSQL_CODE_TYPE specifies the compilation mode for PL/SQL library units.
INTERPRETED:
PL/SQL library units will be compiled to PL/SQL bytecode format. Such modules are executed by the PL/SQL interpreter engine.
NATIVE:
PL/SQL library units (with the possible exception of top-level anonymous PL/SQL blocks) will be compiled to native (machine) code. Such modules will be executed native without incurring any interpreter overhead.
When the value of this parameter is changed, it has no effect on PL/SQL library units that have already been compiled. The value of this parameter is stored persistently with each library unit.
If a PL/SQL library unit is compiled native, all subsequent automatic recompilations of that library unit will use native compilation.
