ORA-913 Compiling JR_Dependency After Upgrade From 6i Release 4.7 to 10gR2 (Doc ID 435313.1)

Last updated on MAY 30, 2012

Applies to:

Oracle Repository - Version 10.1.2.2 and later
Oracle Designer - Version 10.1.2.2 and later
Information in this document applies to any platform.

Symptoms

-- Problem Statement:
After moving and upgrading from Designer 6i Release 4.7 on Oracle 9.2.0.7 to Designer 10.1.2.2 on
Oracle 10gR2,After recompiling/reloading several repository objects that were disabled, missing, or invalid all get fixed BUT JR_Dependency it gives the error
ORA-00913 too many values also errors PLS-00320 and PLS-00302 on DPND_OBJVER_LIST


Changes

This Designer system was migrated from 6i release 4.7 directly to 10gR2 (10.1.2.2)

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