From: markg@mymail.tm (MarkyG) Newsgroups: comp.databases.oracle.server Subject: Re: Urgent help required Date: 8 Aug 2001 03:40:35 -0700 Organization: http://groups.google.com/ Lines: 23 Message-ID: References: <9ko2nl$83k$1@ctss92.sgp.hp.com> <9ko83o$l93$1@ctb-nnrp2.saix.net> NNTP-Posting-Host: 163.166.150.22 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 997267235 16286 127.0.0.1 (8 Aug 2001 10:40:35 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 8 Aug 2001 10:40:35 GMT 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" wrote in message news:<9ko83o$l93$1@ctb-nnrp2.saix.net>... > "LV" 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.