Re: dbms_errlog

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 12 Sep 2007 17:20:28 GMT
Message-ID: <46e81fdb$0$1340$834e42db@reader.greatnowhere.com>

On Wed, 12 Sep 2007 09:01:40 -0700, Mark D Powell wrote:

> On Sep 12, 11:53 am, zino <antony6..._at_gmail.com> wrote:

>> I'm new to oracle, I installed oracle 10g  version 2 and I'm the
>> administrator on this box.  I'm trying to execute the
>> dbms_errlog.create_error_log command  through SQL Plus but I keep
>> getting the error message:
>>
>> SP2-0734: unknown command beginning "dbms_errlo..." - rest of line
>> ignored
>>
>> what am I missing in order to use this package. thanks for help

>
> I do not believe that the dbms_errorlog package is created by default.
> Look in your $ORACLE_HOME/rdbms/admin directory for the package create
> script.
>
> HTH -- Mark D Powell --

It is created by default. DBMS_ERRLOG is created from dbmsutil.sql and dbmsutil.sql is invoked from catproc.sql

oracle14:/i01/app/oracle/product/10.2.0/db_1/rdbms/admin >grep -i dbms_errlog *.sql
dbmsutil.sql:Rem abrumm 03/17/04 - DML Error Logging: add dbms_errlog
dbmsutil.sql:create or replace package dbms_errlog AUTHID CURRENT_USER is dbmsutil.sql:create or replace public synonym dbms_errlog for sys.dbms_errlog

dbmsutil.sql:grant execute on dbms_errlog to public
e1001000.sql:Rem    abrumm      09/29/04 - LRG 1745604: drop dbms_errlog 
e1001000.sql:Rem Drop dbms_errlog package
e1001000.sql:drop package sys.dbms_errlog;
e1001000.sql:drop public synonym dbms_errlog;

oracle14:/i01/app/oracle/product/10.2.0/db_1/rdbms/admin >grep dbmsutil catproc.sql

Rem     lvbcheng   03/01/05 - Split DBMS_ASSERT from dbmsutil.sql 
Rem     liwong     06/29/04 - load dbmsany before dbmsutil

Rem Views for Application context ( dbmsutil and prvtutil depends on it ) @@dbmsutil
oracle14:/i01/app/oracle/product/10.2.0/db_1/rdbms/admin >

Second, the problem is in the syntax. I believe that the OP needs a begin/ end block or "exec" prefix.

-- 
http://www.mladen-gogala.com

Received on Wed Sep 12 2007 - 12:20:28 CDT