???? Whats going wrong with dbms_output ?????

From: Arkusa GbR <arkusa_at_t-online.de>
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

Original text of this message