Ant中执行Oracle存储过程
Ant中执行Oracle存储过程,同样的Oracle dll脚本: 从错误上看是一行结尾没有
同样的Oracle dll脚本:
在Ant中运行出现错误如下
06/08/12 14:22:59.800 INFO: [ProcessWrapper] [STDOUT] cleanup.db.logging:
06/08/12 14:23:00.232 INFO: [ProcessWrapper] [STDOUT] [sql] Executing resource: /root/installation/DSEngine/work/silver-ion-ui-1/scripts/cleanupDDL/oracle/drop_commonlogging.ddl
06/08/12 14:23:00.247 INFO: [ProcessWrapper] [STDERR] [sql] Failed to execute: declare c int; begin select count(*) into c from user_tables where table_name = upper('ACTIVESTARTTIMES');if c = 1 then execute immediate 'drop table "ACTIVESTARTTIMES" cascade constraints';c:=0;end if
06/08/12 14:23:00.267 INFO: [ProcessWrapper] [STDERR]
06/08/12 14:23:00.268 INFO: [ProcessWrapper] [STDERR] BUILD FAILED
06/08/12 14:23:00.268 INFO: [ProcessWrapper] [STDERR] java.sql.SQLException: ORA-06550: line 1, column 201:
06/08/12 14:23:00.268 INFO: [ProcessWrapper] [STDERR] PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
06/08/12 14:23:00.268 INFO: [ProcessWrapper] [STDERR]
06/08/12 14:23:00.268 INFO: [ProcessWrapper] [STDERR] ;
从错误上看是一行结尾没有';', 可是检查了一下, 每一行结尾, 还有文件结尾的确都有';', 把脚本放到DbVisualizer中执行没有问题, 但在Ant中运行为什么会找不到呢?
上一篇: php冒泡排序解决思路
推荐阅读
-
Oracle数据备份过程中遇BUG_ORA-27054 NFS file system
-
Oracle学习笔记之有返回列表的存储过程
-
MySql中创建存储过程_MySQL
-
Oracle中利用10053事件来分析Oracle是如何做出最终的执行计划
-
Oracle 通过存储过程删除两个表中符合条件的记录
-
Oracle Procedure 存储过程语法
-
sqlserver存储过程中SELECT 与 SET 对变量赋值的区别
-
Oracle实践--PL/SQL综合之分页存储过程
-
sqlserver 存储过程中的top+变量使用分析(downmoon)
-
Oracle执行计划中的连接方式nested loops join、sort merge joinn、hash join