Oracle Application Express (MOSC)

MOSC Banner

AD_CTX_DDL.CREATE_SECTION_GROUP must be declared

edited Oct 7, 2014 10:02AM in Oracle Application Express (MOSC) 1 commentAnswered

After Datapump impdp from Linux to SPARC I have 4 APEX objects which are invalid

alter package APPS.OKC_ARTICLE_KEYWORD_PVT compile body;

alter package APPS.OKC_CHR_KEYWORD_PVT compile body;

alter package APPS.OKC_REP_CONTRACT_SEARCH_PVT compile body;

alter package APPS.OKC_TEMPLATE_KEYWORD_PVT compile body;

They will not recompile cleanly. All the rest of APEX is fine.

SQL> alter package APPS.OKC_ARTICLE_KEYWORD_PVT compile body;

Warning: Package Body altered with compilation errors.

SQL> show errors

Errors for PACKAGE BODY APPS.OKC_ARTICLE_KEYWORD_PVT:

LINE/COL ERROR

-------- -----------------------------------------------------------------

49/4 PL/SQL: Statement ignored

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center