Re: SP2-0042 Unknown Command

Sybrand Bakker wrote:

> "Henry Hayden" <gumzilla_at_voicenet.com> wrote in message
> news:3BEA0EB4.8668E8BA_at_voicenet.com...
> > I've been having a problem using the DBMS_OUTPUT package in Oracle
> > 8.1.5. In SQL*Plus, if I execute a simp-le command such as:
> >
> > dbms_output.put_line("Hello!");
> >
> > I get the following error message:
> >
> > SQL> dbms_output.put_line("Hello!");
> > SP2-0042: unknown command beginning "dbms_outpu..." - rest of line
> > ignored.
> >
> > I have made sure to set serveroutput on. After some digging, I found
> > that the DBMS_OUTPUT synonym should be created as part of the original
> > installation via the CATPROC.SQL script, which must be run while logged
> > in as SYS. I did so, to no avail.
> >
> > If anyone has any clues, I'd appreciate the help.
> >
> >
> > Henry
> >
>
> it is
> begin
> dbms_output.put_line("Hello!");
> end;
> /
> in all Oracle sw
> or
> execute dbms_output.put_line("Hello!");
>
> in sql*plus only.
> This applies to _all_ procedure calls, they need to be in an anonymous
> pl/sql block
>
> Hth
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address

I had tried using EXECUTE before, as well, but the error message is a little different- it says that "identifier 'Hello!' must be initialized.

Any other ideas, perhaps? Thanks!

Henry Received on Thu Nov 08 2001 - 14:11:46 CST