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]>
