Message-Id: <10488.105032@fatcity.com> From: Benhayoune khalid Date: Fri, 5 May 2000 08:49:48 -0000 Subject: RE: Missing Packages This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------ =_NextPart_001_01BFB66E.DEA35490 Content-Type: text/plain run ${ORACLE_HOME}/rdbms/admin/catproc.sql and recompile all your packages, functions and procedures and triggers which are, eventually, INVALID. -----Message d'origine----- De : root@fatcity.com [mailto:root@fatcity.com]De la part de Michael Johnson Envoye : ven. 5 mai 2000 09:41 A : Multiple recipients of list ORACLE-L Objet : Missing Packages Hi all, I just created a new db with the create database command. Everything seemed to be working fine except that the dba views were missing so I ran catalog.sql. Now sqlplus works fine except that when I log in, I get the following error. How can I get the following package? I checked in the /rdbms/admin directory but couldn't find anything. Any ideas? Thx ------------------ Error accessing package DBMS_APPLICATION_INFO ORA-06554: package DBMS_STANDARD must be created before using PL/SQL __________________________________________________ Do You Yahoo!? Send instant messages & get email alerts with Yahoo! Messenger. http://im.yahoo.com/ -- Author: Michael Johnson INET: mjohnson138@yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------ =_NextPart_001_01BFB66E.DEA35490 Content-Type: text/html Content-Transfer-Encoding: quoted-printable RE: Missing Packages

run ${ORACLE_HOME}/rdbms/admin/catproc.sql and = recompile all your packages, functions and procedures and triggers = which are, eventually, INVALID.

-----Message d'origine-----
De : root@fatcity.com [mailto:root@fatcity.com]De la part de = Michael
Johnson
Envoye : ven. 5 mai 2000 09:41
A : Multiple recipients of list ORACLE-L
Objet : Missing Packages


Hi all, I just created a new db with the = create
database command.  Everything seemed to be = working
fine except that the dba views were missing so I = ran
catalog.sql.  Now sqlplus works fine except = that when
I log in, I get the following error.  How can I = get
the following package?  I checked in the = /rdbms/admin
directory but couldn't find anything.  Any = ideas?  Thx

------------------

Error accessing package DBMS_APPLICATION_INFO
ORA-06554: package DBMS_STANDARD must be = created
before using PL/SQL



__________________________________________________
Do You Yahoo!?
Send instant messages & get email alerts with = Yahoo! Messenger.
http://im.yahoo.com/
--
Author: Michael Johnson
  INET: mjohnson138@yahoo.com

Fat City Network Services    -- (858) = 538-5051  FAX: (858) 538-5051
San Diego, = California        -- Public Internet = access / Mailing Lists
---------------------------------------------------------------= -----
To REMOVE yourself from this mailing list, send an = E-Mail message
to: ListGuru@fatcity.com (note EXACT spelling of = 'ListGuru') and in
the message BODY, include a line containing: UNSUB = ORACLE-L
(or the name of mailing list you want to be removed = from).  You may
also send the HELP command for other information =