sqlplus中执行pkg报编译错误，使用plsql dev打开重编译问题消失

repentance

环境：AIX5300 + Oracle10204
问题描述：sqlplus中执行pkg报编译错误，使用plsql dev打开重编译问题消失，找不到问题所在

过程描述：
SQL> set define off
SQL> set echo off
SQL> @PKG_UTILITY.pck
Package created.
Warning: Package Body created with compilation errors.
SQL> alter package pkg_utility compile;
Warning: Package altered with compilation errors.
SQL>  alter package pkg_utility compile body;
Warning: Package Body altered with compilation errors.
SQL> show error
Errors for PACKAGE BODY PKG_UTILITY:
LINE/COL ERROR
-------- -----------------------------------------------------------------
159/24   PLS-00103: Encountered the symbol "OPENED" when expecting one of
         the following:
         ) , * & | = - + < / > at in is mod remainder not rem => ..
         <an exponent (**)> <> or != or ~= >= <= <> and or like LIKE2_
         LIKE4_ LIKEC_ between || member SUBMULTISET_


plsql dev使用edit 打开，点击编译，成功。

repentance

客户端字符集设置的有问题，改为NLS_LANG=american_america.ZHS16GBK 问题解决

Maclean Liu(刘相兵

把该包的SQL DDL发出来