???? Whats going wrong with dbms_output ?????
Date: 1996/10/26
Message-ID: <54u83e$2rp_at_news00.btx.dtag.de>#1/1
Is there anyone who can help me getting output from stored procedures?
When I check the package dbms_output using the sys-account, all
works fine.
When I am connected as user, the following error occurs:
Connected to:
Oracle7 Workgroup Server Release 7.1.3.3.3 - Production Release
PL/SQL Release 2.1.3.2.1 - Production
SQL> set serveroutput on;
ERROR:
ORA-04068: Der bestehende Status der Pakete wurde aufgehoben ORA-04067: Ausführung gescheitert, package body "user.DBMS_OUTPUT" existiert nicht ORA-06508: PL/SQL: aufgerufene Programm-Einheit ist nicht zu finden ORA-06512: in Zeile 1
translating to english (I am not familiar with the origin error messages:
ORA-04068: existing state of the packages has been set free ORA-04067: execution was canceled, package body "user.DBMS_OUTPUT" does not exist ORA-06508: PL/SQL: called program-unit could not be found ORA-06512: in line 1
I know that it has something to do with privileges or pathes to the packages. What I tried up to now:
1.) connect as sys/<password>, then to execute the statement
SQL> set serveroutput on;
and then to connect as user, but the error is the same.
2.) Then I granted all the priviledges, sys has to the account user, (Oracle UserManager)
but the same error happend.
What is going wrong?
Thanks for all help
/\ / a\ Manfred Tischendorf / s \ / u \ Bruehlstr. 2 / k \ D 74379 Ingersheim / r \ Deutschland / Germany \a / \ / Tel.: +49 7142 9800-27 / +49 171 6821030 \ / Fax: +49 7142 9800-29 \____/ E-Mail: tischendorf_at_arkusa.de \ / WWW: http://www.arkusa.de/ \/Received on Sat Oct 26 1996 - 00:00:00 CEST
-----------------------------------------------------------