DataPump Import: Compilation Of A PLSQL Program Unit May Fail With Error ORA-6544 [PH2_CLY OUT OF BOUNDS IN PH2POP] (Doc ID 1358114.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 to 11.2.0.2 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 28-MAR-2013***

Symptoms

Importing data with Datapump impdp could result in exceptions similar to the following:

ORA-06544: PL/SQL: internal error, arguments: [ph2_cly (0) out of bounds in PH2POP in ph2ima.c:1794.], [], [], [], [], [], [], []

Failing SQL is:
ALTER PROCEDURE "K"."AUD#BP" COMPILE PLSQL_OPTIMIZE_LEVEL= 2 PLSQL_CODE_TYPE= INTERPRETED PLSQL_DEBUG= FALSE PLSCOPE_SETTINGS= 'IDENTIFIERS:NONE' REUSE SETTINGS TIMESTAMP '2011-03-03 18:53:17'

The problem also reproduces with a valid CATPROC component. The procedures can be manually compiled in SQL*Plus.

Changes

Possibly a recent upgrade can trigger the problem.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms