I discovered that using delimitertype="row" in the sql task solved my problem.
-----Original Message----- From: John Lindwall Sent: Tuesday, December 17, 2002 9:40 AM To: 'Ant Users List' Subject: RE: deploying oracle packages using the sql task Robert, Did you ever find a solution for this problem? I'm having the same difficulty. Thanks! John -----Original Message----- From: Anderson, Rob H - VSCM [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 27, 2002 10:47 AM To: '[EMAIL PROTECTED]' Subject: deploying oracle packages using the sql task Has anyone had success deploying oracle packages with the sql task? I have tried to use the sql task as follows: <target name="lib:runsql"> <sql driver="${db.driver}" print="true" url="${db.url}" userid="${db.userid}" password="${db.password}" src="${db.sql.src}" /> </target> Where the following variables are defined: db.driver=oracle.jdbc.driver.OracleDriver db.url=jdbc:oracle:thin:@<myhost>:1521:<mydb> db.userid=<myuser> db.password=<mypass> db.sql.src=load_comment_spec.sql The problem is the build fails with the following error: ############################################################ lib:runsql: Executing file: S:\Build\SCVC\4.2.3 (Build 1)\DATABASE\SCVC\PACKAGES\load_comment_spec.sql Failed to execute: PROCEDURE Check_Duplicate ( pi_eqp_id EQUIPMENT_COMME NTS.EQP_ID%TYPE , pi_bol_cd EQUIPMENT_COMMENTS.BOL_CD%TYPE , pi_scvc_sta t_cd EQUIPMENT_COMMENTS.SCVC_STAT_CD%TYPE , pi_stat_rsn_cd EQUIPMENT_COMMENTS.STAT_RSN_CD%TYPE , pi_cmnt_txt EQUIPMENT_COMMENTS.C MNT_TXT%TYPE ) BUILD FAILED file:S:/Build/SCVC/4.2.3 (Build 1)/DATABASE/SCVC/PACKAGES/build_lib.xml:44: java.sql.SQLException: O RA-00900: invalid SQL statement Total time: 4 seconds ############################################################ If I run the same file with sqlplus it works fine: sqlplus <myuser>/<mypassword>@<mydb> @load_comment_spec.sql Any ideas? Robert Anderson Software Configuration Management Vector SCM 503-450-6514 [EMAIL PROTECTED] -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
