dbms_output - Error

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; 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) ****