执行如下操作:
c:\wrap iname=c:\a.sql
PL/SQL Wrapper: Release 8.1.7.0.0 - Production on Tue Nov 27 22:26:48 2001 Copyright (c) Oracle Corporation 1993, 2000. All Rights Reserved. Processing a.sql to a.plbc:\进入sqlplus执行:
SQL>@d:a.plb
Warning: Package Body created with compilation errors.SQL> show error
Errors for PACKAGE BODY PKG_STOP_UNITCAL:LINE/COL ERROR
-------- -----------------------------------------------------------------
48/13 PL/SQL: SQL Statement ignored
71/59 PL/SQL: ORA-00933: SQL command not properly ended
301/73 PLS-00049: bad bind variable '59'
301/94 PLS-00049: bad bind variable 'MI'
328/85 PLS-00049: bad bind variable 'MI'
332/81 PLS-00049: bad bind variable 'MI'
337/51 PLS-00049: bad bind variable 'MI'
339/66 PLS-00049: bad bind variable 'MI'
342/89 PLS-00049: bad bind variable 'MI'
346/64 PLS-00049: bad bind variable 'MI'
349/85 PLS-00049: bad bind variable 'MI'LINE/COL ERROR
-------- -----------------------------------------------------------------
387/66 PLS-00049: bad bind variable 'MI'
399/54 PLS-00049: bad bind variable 'MI'
427/80 PLS-00049: bad bind variable 'MI'
432/67 PLS-00049: bad bind variable 'MI'
435/63 PLS-00049: bad bind variable 'MI'
438/95 PLS-00049: bad bind variable 'MI'
479/55 PLS-00049: bad bind variable 'MI'
481/55 PLS-00049: bad bind variable 'MI'
483/59 PLS-00049: bad bind variable 'MI'
SQL>加密的存储过程在加密前执行没有问题,加密后再执行就出过这种情况。各位有谁能帮忙解决?我先谢了。
c:\wrap iname=c:\a.sql
PL/SQL Wrapper: Release 8.1.7.0.0 - Production on Tue Nov 27 22:26:48 2001 Copyright (c) Oracle Corporation 1993, 2000. All Rights Reserved. Processing a.sql to a.plbc:\进入sqlplus执行:
SQL>@d:a.plb
Warning: Package Body created with compilation errors.SQL> show error
Errors for PACKAGE BODY PKG_STOP_UNITCAL:LINE/COL ERROR
-------- -----------------------------------------------------------------
48/13 PL/SQL: SQL Statement ignored
71/59 PL/SQL: ORA-00933: SQL command not properly ended
301/73 PLS-00049: bad bind variable '59'
301/94 PLS-00049: bad bind variable 'MI'
328/85 PLS-00049: bad bind variable 'MI'
332/81 PLS-00049: bad bind variable 'MI'
337/51 PLS-00049: bad bind variable 'MI'
339/66 PLS-00049: bad bind variable 'MI'
342/89 PLS-00049: bad bind variable 'MI'
346/64 PLS-00049: bad bind variable 'MI'
349/85 PLS-00049: bad bind variable 'MI'LINE/COL ERROR
-------- -----------------------------------------------------------------
387/66 PLS-00049: bad bind variable 'MI'
399/54 PLS-00049: bad bind variable 'MI'
427/80 PLS-00049: bad bind variable 'MI'
432/67 PLS-00049: bad bind variable 'MI'
435/63 PLS-00049: bad bind variable 'MI'
438/95 PLS-00049: bad bind variable 'MI'
479/55 PLS-00049: bad bind variable 'MI'
481/55 PLS-00049: bad bind variable 'MI'
483/59 PLS-00049: bad bind variable 'MI'
SQL>加密的存储过程在加密前执行没有问题,加密后再执行就出过这种情况。各位有谁能帮忙解决?我先谢了。
看你运行时报的错,说是绑定变量的问题,查找一下你sql中绑定变量相关的地方。