Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: [Q] system.utl_recomp compile error ????

RE: [Q] system.utl_recomp compile error ????

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Mon, 6 Mar 2006 13:47:31 -0500
Message-ID: <F4C27E77F7A33E4CA98C19A9DC6722A2BBA4CA@EXCHANGE.corp.perceptron.com>


Start with:

Show errors package body utl_recomp;

to find, what are the specific errors.

Btw., did you try to recompile it when connected as system (or under some other account)?

Igor

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of dba1 mcc Sent: Monday, March 06, 2006 1:37 PM
To: oracle-l_at_freelists.org
Subject: [Q] system.utl_recomp compile error ????

I by accident run "@?/rdbms/admin/utlrp" use "system" account. I have error come out:

    SQL> alter package system.utl_recomp compile body;

    Warning: Package Body altered with compilation errors.

Anyone know how to get ride of this problem?

Thanks.



Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Mon Mar 06 2006 - 12:47:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US