Return-Path: 
 <user-return-55264-apmail-ant-user-archive=ant.apache.org@ant.apache.org>
Delivered-To: apmail-ant-user-archive@www.apache.org
Received: (qmail 62854 invoked from network); 19 Mar 2006 14:31:25 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 19 Mar 2006 14:31:25 -0000
Received: (qmail 55601 invoked by uid 500); 19 Mar 2006 14:31:22 -0000
Delivered-To: apmail-ant-user-archive@ant.apache.org
Received: (qmail 55185 invoked by uid 500); 19 Mar 2006 14:31:19 -0000
Mailing-List: contact user-help@ant.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:user-unsubscribe@ant.apache.org>
List-Help: <mailto:user-help@ant.apache.org>
List-Post: <mailto:user@ant.apache.org>
List-Id: "Ant Users List" <user.ant.apache.org>
Reply-To: "Ant Users List" <user@ant.apache.org>
Delivered-To: mailing list user@ant.apache.org
Received: (qmail 55174 invoked by uid 99); 19 Mar 2006 14:31:19 -0000
Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 19 Mar 2006 06:31:19 -0800
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=HTML_MESSAGE,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (asf.osuosl.org: domain of andrewgoktepe@gmail.com
 designates 64.233.184.205 as permitted sender)
Received: from [64.233.184.205] (HELO wproxy.gmail.com) (64.233.184.205)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 19 Mar 2006 06:31:18 -0800
Received: by wproxy.gmail.com with SMTP id i12so849548wra
        for <user@ant.apache.org>; Sun, 19 Mar 2006 06:30:58 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references;
        b=gnUX3G9X6rsj39z6ql2ZBPWj/Rp0eMrq3hNBiFOTFVFYqwr1Dac5G0ijaK397O24bQH0V3WDypeebpoGermbedcsiDWmblBnOzlsOVn/AAxwBy9qNExZQ8yD13Wm07Ay6PRITMOyfFkq+Qm5VroebkHegbqSUTxXd0PNGTIkFco=
Received: by 10.54.78.7 with SMTP id a7mr1411631wrb;
        Sun, 19 Mar 2006 06:30:57 -0800 (PST)
Received: by 10.54.124.19 with HTTP; Sun, 19 Mar 2006 06:29:57 -0800 (PST)
Message-ID: <98c2b60d0603190629i5082af04nea848feb3271050f@mail.gmail.com>
Date: Sun, 19 Mar 2006 08:29:57 -0600
From: "Andrew Goktepe" <andrewgoktepe@gmail.com>
To: "Ant Users List" <user@ant.apache.org>
Subject: Re: SQL Task: errors loading oracle Packages that contain stored
 procedures.
In-Reply-To: <200603172111.k2HLBDK3015072@barriere241.nike.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_2984_27711089.1142778597423"
References: <200603172111.k2HLBDK3015072@barriere241.nike.com>
X-Virus-Checked: Checked by ClamAV on apache.org
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

------=_Part_2984_27711089.1142778597423
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

You could also try the <sqlplus> task available from Incanto:
http://incanto.sourceforge.net/usage-sqlplus.html

-Andrew

On 3/17/06, Anderson, Rob (Global Trade) <Rob.Anderson@nike.com> wrote:
>
> 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=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>
> >
> > 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
>
>

------=_Part_2984_27711089.1142778597423--