SP2-0042 Unknown Command

From: Henry Hayden <gumzilla_at_voicenet.com>
Date: Thu, 08 Nov 2001 04:46:35 GMT
Message-ID: <3BEA0EB4.8668E8BA@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 Received on Wed Nov 07 2001 - 22:46:35 CST