CREATE OR REPLACE FUNCT"> Tek-Tips: Oracle: Oracle release 11g - sqlplus - how to see compilation errors
Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

sqlplus - how to see compilation errorsHelpful Member! 

Calator (Programmer) (OP)
8 Feb 11 22:21
I get a "function created with compilation errors" message but don't get the errors displayed - how can I see what the errors were?
SQL> CREATE OR REPLACE FUNCTION "MERUSER"."BB_GET_SUPPLIER_NAME" (I_SUPPLIER_NO IN CHAR) RETURN CHAR AS V_SUPPLIER_NAME meruser.MSV200.SUPPLIER_NAME%TYPE;SELECT SUPPLIER_NAME INTO V_SUPPLIER_NAME FROM meruser.MSV200 WHERE SUPPLIER_NO = I_SUPPLIER_NO; RETURN V_SUPPLIER_NAME; END;
  2  /

Warning: Function created with compilation errors.

SQL> show errors
No errors.
 
Helpful Member!  Dagon (MIS)
9 Feb 11 4:12

CODE

SELECT * FROM ALL_ERRORS WHERE NAME = 'BB_GET_SUPPLIER_NAME'
and owner = 'MERUSER';

For Oracle-related work, contact me through Linked-In.

Calator (Programmer) (OP)
11 Feb 11 0:54
Thank - that works ok - however what I would need is ther errros to be logged into the spool file that documents the process of creating views and functions form an automated script. there are hundreds of functions/views created, the output is spooled, then I need to check if there were any errors (this curently happens as the warning message is logged) and if errors occurred I need to see what they were (this does not happen). The script has coded 'Show errors' aftre each Create statement, this was supposed to log the errors, but it does not happen. Any solution? Thanks  
Dagon (MIS)
11 Feb 11 3:38
Obviously, you could just replace your show errors with the select statement.  Alternatively, why don't you just do a general "select * from all_errors" after everything has run and see which packages have errors logged against them ?

For Oracle-related work, contact me through Linked-In.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close