asked on

Oracle Errors while connecting to a database

I am trying to connect to a Oracle 10.2.0.2 database and i connect succesfully but get the following erros before connecting. Once i connect i try to run some sql scripts and they a error out, any ideas?

Please help!

*************************************************************************************************
Copyright (c) 1982, 2004, Oracle. All rights reserved.

ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.DISABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_APPLICATION_INFO.SET_MODULE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Error accessing package DBMS_APPLICATION_INFO
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL>

rbrooker

Hi,

http://www.orafaq.com/forum/t/5066/0/
http://forums.oracle.com/forums/thread.jspa?threadID=44594&tstart=0&messageID=196021

good luck :)

lonerangerls

The DBMS_OUTPUT package is created when the Oracle database is installed. You many need to run The dbmsoutp.sql script or create synonyms/give permission to the current schema to see them.
DBMS_APPLICATION_INFO apparently is not available in you current version.

Are you running Oracle XE?

LS

crishna1

ASKER

This used to work perfect till yeasterday, not sure what happened, as shown above ,
i am using Oracle EE.
rbrooker, from your first link , i verified that the value in DUAL is already X.
On the second link , it shows to set SQL> set flagger off, but looks like this works temporarily, only after i login and only for one particular session, how do i permannetly fix it.
I have the following three errors everytime i login, how to fix the rest?

***********************************************
ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_OUTPUT.DISABLE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

ERROR:
ORA-06550: line 1, column 7:
PLS-00201: identifier 'DBMS_APPLICATION_INFO.SET_MODULE' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

Error accessing package DBMS_APPLICATION_INFO
SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.

rbrooker

Hi,

there is a glogin.sql ( global ) and a login.sql ( local ) that you can alter to turn off flagger.

http://www.adp-gmbh.ch/ora/sqlplus/autotrace.html

good luck :)

crishna1

ASKER

i dropped and recreated the database and everything seems to working fine now.

ASKER CERTIFIED SOLUTION

Computer101

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial