I'd be quite surprised if it did what I suspect you want it to do even once
you've fixed that.
Assuming you have serveroutput on it will just display the string:
SELECT TOURDATE FROM USPS.REPORTSELECT
on the screen.
(basically, dbms_output.put_line just takes a string, a date or a number and
outputs it to the
screen in the sql*plus session). If only it was that simple...
Thomas Kyte <tkyte_at_us.oracle.com> wrote in message
news:37727368.713015_at_newshost.us.oracle.com...
> 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 - 17:35:38 CDT
