Ant executes the Oracle stored procedure, the same Oracledll Script: the error indicates that the end of a row does not exist
Ant executes the Oracle stored procedure, the same Oracle dll script: the error indicates that the end of a row does not exist
The same Oracle dll script:
The following error occurs when running in 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];
From the error point of view, there is no ';' at the end of a line, but check that there are ';' At the end of each line and the end of the file. There is no problem to put the script in DbVisualizer for execution, but why can't I find it when running it in Ant?