Re: Urgent help required

Given the phrases ICD vector, x.sql and y.sql I wonder if we are looking at the remains of an application that has been a-removed or b-not installed properly rather than an Oracle problem, per se. THe SUADM as the package owner also makes me suspicious, leaning to b.

Joe Maloney, CSP,CCP,CDP, 07C (thinking maybe I have have enough alphabet soup.)

markg_at_mymail.tm (MarkyG) wrote in message news:<ab87195e.0108080240.50a4bae7_at_posting.google.com>...
> 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 - 14:49:46 CDT