Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: DBMS_OUTPUT

Re: DBMS_OUTPUT

From: Mark C. Stock <mcstockX_at_Xenquery>
Date: Wed, 8 Sep 2004 13:21:28 -0400
Message-ID: <IbOdnc_iRpwGoqLcRVn-iQ@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 - 12:21:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US