Hi all!
The package body APEX_030200.WWV_FLOW_HELP become invalid after Oracle Text installation with the follow errors:
Compilation errors for PACKAGE BODY APEX_030200.WWV_FLOW_HELP #13#10Error: PL/SQL: ORA-00942: table or view does not exist Line: 189 #13#10Error: PL/SQL: SQL Statement ignored Line: 188 #13#10Error: PLS-00201: identifier 'CTX_DDL.DROP_PREFERENCE' must be declared Line: 191 #13#10Error: PL/SQL: Statement ignored Line: 191 #13#10Error: PL/SQL: ORA-00942: table or view does not exist Line: 197 #13#10Error: PL/SQL: SQL Statement ignored Line: 196 #13#10Error: PLS-00201: identifier 'CTX_DDL.DROP_PREFERENCE' must be declared Line: 199 #13#10Error: PL/SQL: Statement ignored Line: 199 #13#10Error: PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be declared Line: 261 #13#10Error: PL/SQL: Statement ignored Line: 261 #13#10Error: PLS-00201: identifier 'CTX_DDL.SET_ATTRIBUTE' must be declared Line: 262 #13#10Error: PL/SQL: Statement ignored Line: 262 #13#10Error: PLS-00201: identifier 'CTX_DDL.SET_ATTRIBUTE' must be declared Line: 265 #13#10Error: PL/SQL: Statement ignored Line: 265 #13#10Error: PLS-00201: identifier 'CTX_DDL.CREATE_PREFERENCE' must be declared Line: 280 #13#10Error: PL/SQL: Statement ignored Line: 280 #13#10Error: PLS-00201: identifier 'CTX_DOC.FILTER' must be declared Line: 292 #13#10Error: PL/SQL: Statement ignored Line: 292 #13#10Error: PLS-00201: identifier 'CTX_DOC.FILTER' must be declared Line: 312 #13#10Error: PL/SQL: Statement ignored Line: 312
It happens bassically because APEX schema has not been granted with execute privileges for CTX_DDL and CTX_DOC. The note below it’s exactly about it:
The WWV_FLOW_HELP PACKAGE Status is Invalid After Installing Oracle Text (Doc ID 1335521.1)
The solution is simple:
mydb> grant execute on ctx_ddl to APEX_030200; Grant succeeded. mydb> grant execute on ctx_doc to APEX_030200; Grant succeeded. mydb> alter package APEX_030200.WWV_FLOW_HELP compile; Package altered. mydb> alter package APEX_030200.WWV_FLOW_HELP compile body; Package body altered.
Have a nice day!
Matheus.