Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Ant Users List" <user@ant.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Content-class: urn:content-classes:message
MIME-Version: 1.0
Subject: RE: SQL Task: errors loading oracle Packages that contain
 stored procedures.
Date: Fri, 17 Mar 2006 13:08:23 -0800
Message-ID: <200603172111.k2HLBDK3015072@barriere241.nike.com>
Thread-Topic: SQL Task: errors loading oracle Packages that contain
 stored procedures.
Thread-Index: AcZKBVYvmMAmARGzQqeaHQVU+JI+ewAAQUQg
From: "Anderson, Rob (Global Trade)" <Rob.Anderson@nike.com>
To: "Ant Users List" <user@ant.apache.org>
Content-Type: text/plain;
 charset=us-ascii
Content-Transfer-Encoding: quoted-printable

Those statements...
@ggov_applications.spc
@ggov_applications.bdy

are not standard sql, they are specific to oracle's sqlplus. IMHO, Your
best option is to create a fileset, then run each file through the sql
task using the <foreach> task from ant-contrib.

-Rob Anderson


> -----Original Message-----
> From: vikram shevde [mailto:vshevde@hotmail.com]=20
> Sent: Friday, March 17, 2006 12:56 PM
> To: user@ant.apache.org
> Subject: SQL Task: errors loading oracle Packages that=20
> contain stored procedures.
>=20
> All,
>=20
> I tried my best and searched this list for a solution to my=20
> problem before posting it, and did find a few suggestions,=20
> but am still stuck..so please bear with me.
>=20
> Problem: I have a SQL file that loads our entire schema's=20
> oracle stored procedure bodies and signatures( spc and bdy)=20
> by loading the individual packages using the=20
> @<file-path-and-name> format. I want to use the SQL task to=20
> load and compile these from version control during a build. I=20
> am using the following ANT SQL task (am using Ant 1.6.5):
>=20
> <sql rdbms=3D"oracle"
> userid=3D"dev"
> password=3D"password"
> =
classpath=3D"D:\bea\weblogic81\server\ext\jdbc\oracle\920\ojdbc14_g.jar"
> driver=3D"oracle.jdbc.driver.OracleDriver"
> url=3D"jdbc:oracle:thin:@phoenix:1521:dev"
> delimiter=3D"/"
> delimitertype=3D"row"
> keepformat=3D"yes">
> <transaction src=3D"D:\cruisecontrol\projects\srcDB\testDB.sql"/>
> </sql>
>=20
> Also, here are the contents of the testlDB.sql:
>=20
> -------------------------------------------------------
> -- Export file for user DEV--
> -- Created on 1/30/2006, 2:56:24 PM --
> -------------------------------------------------------
>=20
> @ggov_applications.spc
> @ggov_applications.bdy
> /
> -----------------------------------------------------
>=20
> Each of the above two files(ggov_applications.spc and=20
> ggov_applications.bdy) is a package signature and body=20
> respectively, containing many stored procedures, ending with a /.
>=20
> When i run this task, i get the following error:
>=20
> D:\cruisecontrol\projects\grantsonline\build.xml:302:=20
> java.sql.SQLException:=20
> ORA
> -00900: invalid SQL statement
>=20
>         at=20
> org.apache.tools.ant.taskdefs.SQLExec.execute(SQLExec.java:398)
>         at
> org.apache.tools.ant.UnknownElement.execute(UnknownElement.java:275)
>         at org.apache.tools.ant.Task.perform(Task.java:364)
>         at org.apache.tools.ant.Target.execute(Target.java:341)
>         at org.apache.tools.ant.Target.performTasks(Target.java:369)
>         at
> org.apache.tools.ant.Project.executeSortedTargets(Project.java:1216)
>=20
> Thanks for any help in advance!
>=20
> Vik.
>=20
>=20
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@ant.apache.org For=20
> additional commands, e-mail: user-help@ant.apache.org
>=20
>=20
>=20


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