Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

dbms_output.put_line within sqlplus

480196Mar 20 2007 — edited Mar 20 2007

Hello,
The procedure I am running within sqlplus is not displaying the output of the dbms_output.put_line to the screen. I have read quite a bit of posts on this forum, but still cannot understand what the workaround is to it. This is a snippet of my code:
<br><br><b>

set echo off feedback off verify off
set serveroutput on

connect sys/&SYSPASS1 as sysdba;

   BEGIN
   CASE '&2.'
    WHEN 'user'
       THEN do something
       ELSE 
      dbms_output.enable(5000);
      dbms_output.put_line('Error: Invalid command');
    END CASE;
  END;
</b>
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 17 2007
Added on Mar 20 2007
6 comments
661 views