How to see errors after compilation.

hi,

can you try this;

select name, text from user_errors where name='your_script_name'

Srikanth,

Run it as a part of script

show errors
/

REgards

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> 

try this,

SQL> show err;
No errors

Regards,
Christian Balz

Try this

select * from user_errors;

--Shows all errors, you can filter this for your proc.

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