ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "vikram shevde" <vshe...@hotmail.com>
Subject RE: SQL Task: errors loading oracle Packages that contain stored procedures.
Date Sun, 19 Mar 2006 19:43:48 GMT
Thanks for your tip...will try that for sure.

Regards,
Vik.

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



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


Mime
View raw message