Re: DBMS_OUTPUT

David_T MO wrote:
> I'm a long time SQL user but an Oracle newbie and have inherited an
> Oracle database. I'm trying to get DBMS_OUTPUT going but am hitting a
> brick wall. I can describe the package and execute the 'set
> serveroutput on' command, but anytime I attempt to use any procedure
> within the package I get an 'unknown command' error (see below).
> Doesn't matter what user_id I use. I've rerun the dbmsotpt.sql as SYS
> successfully but no joy on using the procedures.
>
> Any suggestions on how to get DBMS_OUTPUT working?
>
> ---
>
> limsd>describe dbms_output;
> PROCEDURE DISABLE
> PROCEDURE ENABLE
> Argument Name Type In/Out
> Default?
> ------------------------------ ----------------------- ------
> --------
> BUFFER_SIZE NUMBER(38) IN DEFAULT
> PROCEDURE GET_LINE
> Argument Name Type In/Out
> Default?
> ------------------------------ ----------------------- ------
> --------
> LINE VARCHAR2 OUT
> STATUS NUMBER(38) OUT
> PROCEDURE GET_LINES
> Argument Name Type In/Out
> Default?
> ------------------------------ ----------------------- ------
> --------
> LINES TABLE OF VARCHAR2(255) OUT
> NUMLINES NUMBER(38) IN/OUT
> PROCEDURE NEW_LINE
> PROCEDURE PUT
> Argument Name Type In/Out
> Default?
> ------------------------------ ----------------------- ------
> --------
> A VARCHAR2 IN
> PROCEDURE PUT
> Argument Name Type In/Out
> Default?
> ------------------------------ ----------------------- ------
> --------
> A NUMBER IN
> PROCEDURE PUT_LINE
> Argument Name Type In/Out
> Default?
> ------------------------------ ----------------------- ------
> --------
> A VARCHAR2 IN
> PROCEDURE PUT_LINE
> Argument Name Type In/Out
> Default?
> ------------------------------ ----------------------- ------
> --------
> A NUMBER IN
>
> limsd>SET SERVEROUTPUT ON;
> limsd>DBMS_OUTPUT.ENABLE;
> SP2-0734: unknown command beginning "DBMS_OUTPU..." - rest of line
> ignored.

SQL> set serveroutput on
SQL> exec dbms_output.enable;

For a full demo go to http://www.psoug.org Click on Morgan's Library
Click on DBMS_OUTPUT

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)