I am trying to use the Ant SQL task to replace a shell scripting solution but I get
errors on a stored procedure.
Is it possible to define stored procedures via Ant SQL?
In the midst of a stored procedure definition ...
select @querystring = "alter table " + @tmptablename + " drop constraint "
+ @constraintname
print @querystring
exec(@querystring)
Ant aborts with
com.sybase.jdbc2.jdbc.SybSQLException: Invalid column name ' drop constraint
'.
This works piped to the Sql interpreter but not as part of a stored proc def via
Ant SQL / JDBC .... any tips?
--
Jack J. Woehr # "[F]ar in the empty sky a solitary esophagus slept
http://www.well.com/~jax # upon motionless wing; everywhere brooded stillness,
http://www.softwoehr.com # serenity, and the peace of God." - Mark Twain
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
