Re: dbms_output - Error

A copy of this was sent to ggarrison <ggarrisonsr_at_hotmail.com> (if that email address didn't require changing) On Thu, 24 Jun 1999 09:36:15 -0800, you wrote:

>I successfully compliled the following code:
>
>Create or replace PROCEDURE TEST
>IS
>BEGIN
>dbms_output.enable(10000) ;
>dbms_output.put_line('SELECT TOURDATE FROM
>USPS.REPORTSELECT');
>END;
>

somebody installed dbms_output under system -- it doesn't belong there. its installed in the SYS account when you install.

log in as system and "drop package dbms_output". You'll probably have to drop and recreate the synonym as well. "drop public synonym dbms_output". "create public synonym dbms_output for sys.dbms_output"

>During the execute USPS.TEST; - I received the following
>message -
>
>SQL> execute USPS.TEST;
>begin USPS.TEST; end;
>*
>ERROR at line 1:
>ORA-04068: existing state of packages has been discarded
>ORA-04067: not executed, package body "SYSTEM.DBMS_OUTPUT"
>does not exist
>ORA-04067: not executed, package body "SYSTEM.DBMS_OUTPUT"
>does not exist
>ORA-06508: PL/SQL: could not find program unit being called
>ORA-06512: at "USPS.TEST", line 6
>ORA-06512: at line 1
>
>Any suggestions - Thanks in advance
>
>
>
>**** Posted from RemarQ - http://www.remarq.com - Discussions Start Here (tm) ****

--
See http://govt.us.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'... Current article is "Part I of V, Autonomous Transactions" updated June 21'st  

Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation Received on Thu Jun 24 1999 - 13:06:53 CDT