4 responses

  1. Scott Wesley
    January 11, 2012

    Noting the Oracle Sql Developer v3.1 disclaimer, might that explain why “sho err” didn’t respond to F5 – run as script (instead of run as statement)? I currently have 3.0.04

    Thanks for this informative & concise post!

    • JeffS
      JeffS
      January 12, 2012

      So I tried the same code in v3.0.0.4, and I see the same behavior in the worksheet as I see in v3.1EA3. The error appears in the Script Output panel.

      PROCEDURE do_nothing compiled
      Warning: execution completed with warning
      4/7 PLS-00103: Encountered the symbol “SHOULD” when expecting one of the following:

      := . ( @ % ;

  2. Scott Wesley
    February 8, 2012

    I may have found my original issue (after upgrading today to 3.1.0.7)
    Nothing happens with “sho err”, but “show err” or “show errors” does work ok.

    • JeffS
      JeffS
      February 8, 2012

      In 11.2.0.3, using ‘sho err’ in SQL*Plus does not work

      SQL> create or replace procedure x is
      2 begin
      3 dbms_output.put_line(x);
      4 null
      5 end procedure x;
      6
      7 sho err
      8 /

      Warning: Procedure created with compilation errors.

      But show err does

      ERROR at line 4:
      ORA-06550: line 4, column 1:
      PLS-00103: Encountered the symbol “END” when expecting one of the following:
      ;

Leave a Reply

 

 

 

Back to top
mobile desktop