ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From John Lindwall <JLindw...@Xifin.com>
Subject RE: deploying oracle packages using the sql task
Date Tue, 17 Dec 2002 17:40:21 GMT
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:Anderson.Rob@vectorscm.com]
Sent: Wednesday, November 27, 2002 10:47 AM
To: 'ant-user@jakarta.apache.org'
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
anderson.rob@vectorscm.com


--
To unsubscribe, e-mail:   <mailto:ant-user-unsubscribe@jakarta.apache.org>
For additional commands, e-mail: <mailto:ant-user-help@jakarta.apache.org>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message