Re: DBMS_OUTPUT

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 8 Sep 2004 13:21:28 -0400
Message-ID: <IbOdnc_iRpwGoqLcRVn-iQ_at_comcast.com>


"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:413f2f66$0$7594$636a15ce_at_news.free.fr...
|
| "David_T MO" <david.thomas_at_cityutilities.net> a écrit dans le message de
| news:4f6c512c.0409080734.7a07d909_at_posting.google.com...
...
>
| > limsd>SET SERVEROUTPUT ON;
| > limsd>DBMS_OUTPUT.ENABLE;
| > SP2-0734: unknown command beginning "DBMS_OUTPU..." - rest of line
| > ignored.
|
| The problem is not with the package.
| The problem is how to execute a package or a PL/SQL statement.
| Maybe looking at SQL*Plus Manual.
| For instance:
|
|
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a90842/ch13.htm#1009731
|
| --
| Regards
| Michel Cadot
|
|
|

as the link indicates, use the SQL*Plus EXECUTE command (only works in SQL*Plus) -- or use an anonymous block. simply wrap your PL/SQL fragment in BEGIN ... END; download the PL/SQL and SQL manuals from the referenced web site and google 'pl/sql tutorial' for more info

++ mcs Received on Wed Sep 08 2004 - 19:21:28 CEST

Original text of this message