deploying oracle packages using the sql task

["Anderson, Rob H - VSCM" <An...@vectorscm.com>]

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
anderson.rob@vectorscm.com


--
To unsubscribe, e-mail:   <ma...@jakarta.apache.org>
For additional commands, e-mail: <ma...@jakarta.apache.org>