Forum Stats

  • 3,735,154 Users
  • 2,247,124 Discussions
  • 7,857,751 Comments

Discussions

How to see errors after compilation.

699390
699390 Member Posts: 21
edited May 13, 2009 11:09PM in SQL & PL/SQL
Hello,

I am new to SQL/Developer.
How do we check the errors after running the script in sql/developer.
Warning: execution completed with warning.

I tried show errors but its not working.
Please help.

Thanks,
Srikanth

Answers

  • asdasdasd
    asdasdasd Member Posts: 20
    hi,

    can you try this;

    select name, text from user_errors where name='your_script_name'
  • OrionNet
    OrionNet Member Posts: 4,542
    Srikanth,

    Run it as a part of script

    show errors
    /

    REgards
    OrionNet
  • 666352
    666352 Member Posts: 1,442
    Hi,
    After you run your script, you execute show errors.

    Reagrds Salim.
    SQL> create or replace function ff return number 
      2  is 
      3  begin 
      4  dbms_output.put_line(pp);
      5  end ;
      6  /
    
    Warning: Function created with compilation errors.
    
    SQL> show errors;
    Errors for FUNCTION FF:
    
    LINE/COL ERROR
    -------- -----------------------------------------------------------------
    4/1      PL/SQL: Statement ignored
    4/22     PLS-00201: identifier 'PP' must be declared
    SQL> 
  • Christian Balz
    Christian Balz Member Posts: 462 Silver Badge
    try this,
    SQL> show err;
    No errors
    Regards,
    Christian Balz
  • SanjayRs
    SanjayRs Member Posts: 3,024
    edited May 13, 2009 7:08PM
    Try this
    select * from user_errors;
    
    --Shows all errors, you can filter this for your proc.
  • 699390
    699390 Member Posts: 21
    Hi everyone,

    Thanks all for your prompt replies.. I actually fixed the problem by trying it in sqlplus. 'SHOW ERRORS' works fine in sqlplus, but it doesnt in sqldeveloper. I would really appreciate any further help.


    I was trying to compile a package body. I tried select * from user_errors; It shows errors only in procedures.

    Srikanth.
  • OrionNet
    OrionNet Member Posts: 4,542
    Hello,

    If you are using sql/developer then you should be able to go to the package and right click and select compile and this should show you errors in bottom pane and in addition you can see errors in user_errors. Now you mentioned in your post you got warning and not errors, and some warning you can safely ignore and if possible if you can post your package code then it will be eaiser to help you out.

    Regards
    OrionNet
This discussion has been closed.