Re: SP2-0042 Unknown Command

"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