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 and later
Oracle Designer - Version and later
Information in this document applies to any platform.


-- Problem Statement:
After moving and upgrading from Designer 6i Release 4.7 on Oracle to Designer 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


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


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