Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: rdbms.output error
Hi Shane,
if you meant the DBMS_OUTPUT package, you can invoke its procedure
PUT_LINE
from SQL*PLUS (if you have installed PL/SQL) by entering
exec is a SQL*PLUS "macro", above, it builds the following anonymous PL/SQL block (which you could enter also in SQL*PLUS):
You can't execute a procedure directly from SQL*PLUS, you'll have to use PL/SQL. Hope this helps
Andreas
Shane wrote:
>
> I want to use rdbms.output in sqlplus, but when I try to issue that
> command I get a message like "unknown command...rest of line ignored" (ie,
> error SP2-0734).
>
> Can I just issue that command on the sqlplus command line at any time?
> How do I make sure it is installed? If I need to install it, where can I
> get it? I know this is simple, but I have done a lot of searching, and
> I'm still pretty much in the dark as to how to approach this. (I'm on a
> Solaris 8 machine with Oracle 8i.)
>
> Thanks.
>
> --
> Author: Shane
> INET: orac_mail_at_shane.economicsamerica.org
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).