Re: What´s wrong with dbms_output ?????

Arkusa GbR wrote:
>
> 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 ni
> ORA-06508: PL/SQL: aufgerufene Programm-Einheit ist nicht zu finden
> ORA-06512: in Zeile 1
>
> Sorry for not translating to english.
> I tried to 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.
>
> 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 any 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/
> \/
> -----------------------------------------------------------
Two things to try together:
1. Grant execute any procedure to <user> 2. Make sure you have a public synonym for dbms_output that points to the correct schema. This should fix it.

Loyal Received on Mon Oct 28 1996 - 00:00:00 CST