最近遇到了一个好奇怪的问题,在我们开发小组这边能够正确跑的plsql,但是去到客户那边update的时候就出问题了,而且是一些编译错误的问题,我已经检查了一遍又一遍了,但是还是觉得没有问题啊.首先声明这个plsq是可以在我这边toad编译和运行的,所以是没有问题的,同样这个plsql也在客户那边跑得好好的,我叫客户发了一个在他们正常跑的plsql给我们,然后我也不作修改地发回给他们,但是他们也同样报错,具体的错误也是一样的.,具体如下:
Line # = 7 Column # = 5 Error Text = PLS-00103: Encountered the symbol "FUNCTION" when expecting one of the following: is as compress compiled wrapped The symbol "is" was substituted for "FUNCTION" to continue.
Line # = 8 Column # = 32 Error Text = PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: ( The symbol "(" was substituted for "VARCHAR2" to continue.
Line # = 9 Column # = 32 Error Text = PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: ( The symbol "(" was substituted for "VARCHAR2" to continue.
Line # = 10 Column # = 30 Error Text = PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: ( The symbol "(" was substituted for "VARCHAR2" to continue.
Line # = 11 Column # = 29 Error Text = PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: ( The symbol "(" was substituted for "VARCHAR2" to continue.
Line # = 12 Column # = 22 Error Text = PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: ( The symbol "(" was substituted for "VARCHAR2" to continue.
Line # = 13 Column # = 24 Error Text = PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: (
Line # = 19 Column # = 9 Error Text = PLS-00103: Encountered the symbol "LI_DEBUG_POS" when expecting one of the following: language
Line # = 230 Column # = 5 Error Text = PLS-00103: Encountered the symbol "PROCEDURE" when expecting one of the following: end not pragma final instantiable order overriding static member constructor map The symbol "static" was substituted for "PROCEDURE" to continue.
Line # = 2278 Column # = 5 Error Text = PLS-00103: Encountered the symbol "FUNCTION" when expecting one of the following: end not pragma final instantiable order overriding static member constructor map
Line # = 2279 Column # = 27 Error Text = PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: (
Line # = 2692 Column # = 1 Error Text = PLS-00103: Encountered the symbol "END" when expecting one of the following: begin function package pragma procedure form
Line # = 7 Column # = 5 Error Text = PLS-00103: Encountered the symbol "FUNCTION" when expecting one of the following: is as compress compiled wrapped The symbol "is" was substituted for "FUNCTION" to continue.
Line # = 8 Column # = 32 Error Text = PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: ( The symbol "(" was substituted for "VARCHAR2" to continue.
Line # = 9 Column # = 32 Error Text = PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: ( The symbol "(" was substituted for "VARCHAR2" to continue.
Line # = 10 Column # = 30 Error Text = PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: ( The symbol "(" was substituted for "VARCHAR2" to continue.
Line # = 11 Column # = 29 Error Text = PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: ( The symbol "(" was substituted for "VARCHAR2" to continue.
Line # = 12 Column # = 22 Error Text = PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: ( The symbol "(" was substituted for "VARCHAR2" to continue.
Line # = 13 Column # = 24 Error Text = PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: (
Line # = 19 Column # = 9 Error Text = PLS-00103: Encountered the symbol "LI_DEBUG_POS" when expecting one of the following: language
Line # = 230 Column # = 5 Error Text = PLS-00103: Encountered the symbol "PROCEDURE" when expecting one of the following: end not pragma final instantiable order overriding static member constructor map The symbol "static" was substituted for "PROCEDURE" to continue.
Line # = 2278 Column # = 5 Error Text = PLS-00103: Encountered the symbol "FUNCTION" when expecting one of the following: end not pragma final instantiable order overriding static member constructor map
Line # = 2279 Column # = 27 Error Text = PLS-00103: Encountered the symbol "VARCHAR2" when expecting one of the following: (
Line # = 2692 Column # = 1 Error Text = PLS-00103: Encountered the symbol "END" when expecting one of the following: begin function package pragma procedure form
因为加密会关系到你用的wrap和客户的wrap是不是相同版本 ...
(至少要客户那边的版本和你一样或更高才行~~)