Article - CS168662

Compiling body of package PK_TIB_OPENITEM_IMPORT fails with PLS-00103 in Windchill Enterprise Systems Integration 10.1

Modified: 17-Apr-2014   


Applies To

  • Windchill Enterprise Systems Integration 10.1 M030

Description

  • Issues executing ESI Oracle Apps SQL scripts MasterConfiguration_OpenItem_all_Mods.sql
  • Compiling body of package PK_TIB_OPENITEM_IMPORT fails with PLS-00103
SQL statement and error(s):
SQL> l
  1* alter package PK_TIB_OPENITEM_IMPORT compile body
SQL> /
 
Warning: Package Body altered with compilation errors.
 
SQL> show error
Errors for PACKAGE BODY PK_TIB_OPENITEM_IMPORT:
 
LINE/COL ERROR                                                                  
-------- -----------------------------------------------------------------      
3980/25  PLS-00103: Encountered the symbol ";" when expecting one of the        
         following:                                                             
         ( - + case mod new not null <an identifier>                            
         <a double-quoted delimited-identifier> <a bind variable>               
         continue avg count current exists max min prior sql stddev             
         sum variance execute forall merge time timestamp interval              
         date <a string literal with character set specification>               
         <a number> <a single-quoted SQL string> pipe                           
         <an alternatively-quoted string literal with character set             
         specification>                                                         
         <an alternatively  
This is a printer-friendly version of Article 168662 and may be out of date. For the latest version click CS168662