Execute the Oracle stored procedure in Ant

Source: Internet
Author: User
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?

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.