查看PL/SQL编译时的错误信息

SQL> select * from v$version;                                      
                                                                   
BANNER                                                             
----------------------------------------------------------------   
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi   
PL/SQL Release 10.2.0.4.0 - Production                             
CORE    10.2.0.4.0      Production                                 
TNS for Solaris: Version 10.2.0.4.0 - Production                   
NLSRTL Version 10.2.0.4.0 - Production                             

set linesize 180                                                                                        
col object_name format a45                                                                              
SELECT owner, object_name, object_type, status                                                          
FROM dba_objects                                                                                        
WHERE status = 'INVALID'                                                                                
     AND                                                                                                
     object_type IN ('PROCEDURE', 'FUNCTION', 'TRIGGER', 'VIEW', 'PACKAGE');                            
                                                                                                        
OWNER                          OBJECT_NAME                                   OBJECT_TYPE         STATUS 
------------------------------ --------------------------------------------- ------------------- -------
OTC_WRHS_POSITION              OTC_WRHS_POSITION_PCK_tmp                     PACKAGE             INVALID

/**************************************************/                          
/* Author: Robinson Cheng                         */                          
/* Blog:   http://blog.csdn.net/robinson_0612     */                          
/* MSN:    robinson_0612@hotmail.com              */                          
/* QQ:     645746311                              */                          
/**************************************************/                          
	                                                                              
--注意该包对象中包体的名字含小写字符，因此编译时使用双引号括起来                
SQL> alter package "OTC_WRHS_POSITION"."OTC_WRHS_POSITION_PCK_tmp" compile body;

SQL> show errors;                                                               
No errors.                                                                      
                                                                                
SQL> show errors package body "OTC_WRHS_POSITION"."OTC_WRHS_POSITION_PCK_tmp";  
No errors.                                                                      

SQL> desc dba_errors;                                                                                                   
Name           Type           Nullable Default Comments                                                                 
-------------- -------------- -------- ------- ---------------------------------------------------------------          
OWNER          VARCHAR2(30)                                                                                             
NAME           VARCHAR2(30)                    Name of the object                                                       
TYPE           VARCHAR2(12)   Y                Type: "TYPE", "TYPE BODY", "VIEW", "PROCEDURE", "FUNCTION",              
"PACKAGE", "PACKAGE BODY", "TRIGGER",                                                                                   
"JAVA SOURCE" or "JAVA CLASS"                                                                                           
SEQUENCE       NUMBER                          Sequence number used for ordering purposes                               
LINE           NUMBER                          Line number at which this error occurs                                   
POSITION       NUMBER                          Position in the line at which this error occurs                          
TEXT           VARCHAR2(4000)                  Text of the error                                                        
ATTRIBUTE      VARCHAR2(9)    Y                                                                                         
MESSAGE_NUMBER NUMBER         Y                                                                                         
                                                                                                                        
SQL> select owner,name,TEXT from dba_errors where owner='OTC_WRHS_POSITION' and name='OTC_WRHS_POSITION_PCK_tmp' and    
  2  sequence=(select max(sequence) from dba_errors where owner='OTC_WRHS_POSITION');                                   
                                                                                                                        
OWNER                NAME                      TEXT                                                                     
-------------------- ------------------------- ------------------------------------------------------------             
OTC_WRHS_POSITION    OTC_WRHS_POSITION_PCK_tmp PLS-00103: Encountered the symbol "ULL" when expecting one o             
                                               f the following:                                                         
                                                                                                                        
                                                  . ( ) , * @ % & = - + < / > at in is mod remainder not re             
                                               m                                                                        
                                                  <an exponent (**)> <> or != or ~= >= <= <> and or like LI             
                                               KE2_                                                                     
                                                  LIKE4_ LIKEC_ between || multiset member SUBMULTISET_                 
                                               The symbol "." was substituted for "ULL" to continue.