Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Urgent help required
Check to see who owns the package dbms_application_info (via
all_source view)
, if it is not system, drop the package and recreate under SYSTEM.
Ensure that you have found the right sql script (under
$ORACLE_HOME/rdbms/admin) which relates to dbms_application_info.
When run under SYSTEM, the correct privileges are given to other users etc which are not done if erun under any other user.
Mark (part OCP qualified!)
"Billy Verreynne" <vslabs_at_onwe.co.za> wrote in message news:<9ko83o$l93$1_at_ctb-nnrp2.saix.net>...
> "LV" <vimala_lourduraj_at_hp.com> wrote
>
> > When I try to run one of my sql script the sqlplus gives an error
> > Error accessing package dbms_application_info
> > Error: ORA-06509 PL/SQL ICD vector missing for this package
>
> Well, seeing that people like to throw educated guesses and OCP certifications
> around... my uneducated (never did the OCP thing and not planning to) guess is
> that you have not run the catproc.sql to create the PL/SQL side (procedural
> option) of the Oracle data dictionary.
Received on Wed Aug 08 2001 - 05:40:35 CDT