Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> 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.
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_at_fatcity.com [mailto:root_at_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
-- Author: Michael Johnson INET: mjohnson138_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing ListsReceived on Fri May 05 2000 - 03:49:48 CDT
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_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 <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3DUS-ASCII"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.0.1459.75"> <TITLE>RE: Missing Packages</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>run ${ORACLE_HOME}/rdbms/admin/catproc.sql and = recompile all your packages, functions and procedures and triggers = which are, eventually, INVALID.</FONT></P> <P><FONT SIZE=3D2>-----Message d'origine-----</FONT> <BR><FONT SIZE=3D2>De : root_at_fatcity.com [<A = HREF=3D"mailto:root_at_fatcity.com" = TARGET=3D"_blank">mailto:root_at_fatcity.com</A>]De la part de = Michael</FONT> <BR><FONT SIZE=3D2>Johnson</FONT> <BR><FONT SIZE=3D2>Envoye : ven. 5 mai 2000 09:41</FONT> <BR><FONT SIZE=3D2>A : Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Objet : Missing Packages</FONT> </P> <BR> <P><FONT SIZE=3D2>Hi all, I just created a new db with the = create</FONT> <BR><FONT SIZE=3D2>database command. Everything seemed to be = working</FONT> <BR><FONT SIZE=3D2>fine except that the dba views were missing so I = ran</FONT> <BR><FONT SIZE=3D2>catalog.sql. Now sqlplus works fine except = that when</FONT> <BR><FONT SIZE=3D2>I log in, I get the following error. How can I = get</FONT> <BR><FONT SIZE=3D2>the following package? I checked in the = /rdbms/admin</FONT> <BR><FONT SIZE=3D2>directory but couldn't find anything. Any = ideas? Thx</FONT> </P> <P><FONT SIZE=3D2>------------------</FONT> </P> <P><FONT SIZE=3D2>Error accessing package DBMS_APPLICATION_INFO</FONT> <BR><FONT SIZE=3D2>ORA-06554: package DBMS_STANDARD must be = created</FONT> <BR><FONT SIZE=3D2>before using PL/SQL</FONT> </P> <BR> <BR> <P><FONT = SIZE=3D2>__________________________________________________</FONT> <BR><FONT SIZE=3D2>Do You Yahoo!?</FONT> <BR><FONT SIZE=3D2>Send instant messages & get email alerts with = Yahoo! Messenger.</FONT> <BR><FONT SIZE=3D2><A HREF=3D"http://im.yahoo.com/" = TARGET=3D"_blank">http://im.yahoo.com/</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Michael Johnson</FONT> <BR><FONT SIZE=3D2> INET: mjohnson138_at_yahoo.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed = from). You may</FONT> <BR><FONT SIZE=3D2>also send the HELP command for other information =