Re: pls-00201: identifier DBMS_OUTPUT.DISABLE

From: Jurij Modic <jmodic_at_src.si>
Date: Tue, 24 Nov 1998 09:28:11 GMT
Message-ID: <365a7966.5418279@news.siol.net>

On Tue, 24 Nov 1998 02:01:07 GMT, hpcheong_at_ncs.com.sg wrote:

>hi,
>
>after i finished creating an instance (execute crdbxxx.sql,crdb2xxx.sql,
>catproc.sql, catalog.sql, pupbld.sql and catdbstn.sql), i realised that when
>i do a sqlplus, i will have this error message - pls-00201: identifier
>DBMS_OUTPUT.DISABLE just before the sql prompt. though i can do all my sql
>statement but it's rather fuuny to have this error message.
>
>on the other hand, the same set of scripts i used to create another instance,
>it is ok! can anyone help? how can i get rid of the error message?

Check your login files that are executed every time you connect with SQL*Plus. Look for files named glogin.sql and login.sql

One (or both) of this two files must have some reference to procedure DBMS_OUTPUT.DISABLE . The reason why you are getting this error might be that you have no public synonym for package DBMS_OUTPUT, owned by SYS. If this is true either create one or change the reference to this package in (g)login.sql so that it will include also the owner, ie SYS.DBMS_OUTPUT.DISABLE .
>thanks in advance...
>
>rgds
>evelyn.

HTH, Jurij Modic <jmodic_at_src.si>
Certified Oracle7 DBA (OCP)

---

The above opinions are mine and do not represent any official standpoints of my employer Received on Tue Nov 24 1998 - 03:28:11 CST