ant-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Harkness, David" <>
Subject RE: using set command in the sql task
Date Thu, 01 Apr 2004 21:52:02 GMT
Edward Peloke wrote:
> I am using the sql task to run a script into my ORacle db.
> The script runs fine unless I use a Set command such as
> SET DEFINE ON, etc.  IF those are in the scripts, I get an
> invalid option error.

It is my understanding that the <sql> task actually uses JDBC directly
to issue your queries and such -- it doesn't go through SQL*Plus.

> How can I get around this?

You can call SQL*Plus directly with the following.

    <exec executable="sqlplus" output="db-init-lookup-identity.log">
        <arg value="-S"/>
        <arg value="${db.user}/${db.pwd}@${db.sid}"/>
        <arg value="@script.sql"/>

David Harkness
Sr. Software Engineer
Sony Pictures Digital Networks
(310) 482-4756

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message