You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@ant.apache.org by Alexander Karnstedt <al...@gmx.de> on 2005/06/12 21:39:02 UTC
New external task: Incanto
Hello,
I've just released an Ant task project named "Incanto" wich intends to
provide support for various oracle database tools. Up to now it's
implementing the SQL*Plus command-line query tool to execute SQL scripts
from Ant build files.
Name: Incanto
Description: Ant tasks to provide support for Oracle database tools
(such as SQL*Plus, Import, Export)
Compatibility: Ant 1.6
URL: http://incanto.sourceforge.net/
Contact: <a href="mailto:alexrk@users.sourceforge.net">Alexander
Karnstedt</a>
License: Apache License, Version 2.0
Could you please add a reference on the external tasks list?
Regards.
Alexander Karnstedt
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@ant.apache.org
For additional commands, e-mail: dev-help@ant.apache.org
Re: New external task: Incanto
Posted by Alexander Karnstedt <al...@gmx.de>.
At 21:43 12.06.2005, you wrote:
>Can I execute Oracle Procedures???
>Wohlgetan!
Gern geschehen!
Yes it's possible to execute PL/SQL blocks as well as shutdown, startup
command's etc.
An example ...
The following task checks whether the database is in ARCHIVELOG mode and
otherwise produces a build exception.
<ora:sqlplus
logon="sys/syspswd@localdb as sysdba"
silent="true"
failonerror="true">
<![CDATA[
WHENEVER SQLERROR EXIT SQL.SQLCODE
declare
v_logmode varchar2(30);
begin
select log_mode into v_logmode from v$database;
if v_logmode != 'ARCHIVELOG' then
raise_application_error (-20101, 'ARCHIVELOG not enabled');
end if;
end;
/
]]>
</ora:sqlplus>
Regards,
Alexander
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@ant.apache.org
For additional commands, e-mail: dev-help@ant.apache.org
Re: New external task: Incanto
Posted by Martin Gainty <mg...@hotmail.com>.
Can I execute Oracle Procedures???
Wohlgetan!
Vielen Danke,
Martin-
----- Original Message -----
From: "Alexander Karnstedt" <al...@gmx.de>
To: <de...@ant.apache.org>
Sent: Sunday, June 12, 2005 3:39 PM
Subject: New external task: Incanto
> Hello,
>
> I've just released an Ant task project named "Incanto" wich intends to
> provide support for various oracle database tools. Up to now it's
> implementing the SQL*Plus command-line query tool to execute SQL scripts
> from Ant build files.
>
>
> Name: Incanto
> Description: Ant tasks to provide support for Oracle database tools
> (such as SQL*Plus, Import, Export)
> Compatibility: Ant 1.6
> URL: http://incanto.sourceforge.net/
> Contact: <a href="mailto:alexrk@users.sourceforge.net">Alexander
> Karnstedt</a>
> License: Apache License, Version 2.0
>
>
> Could you please add a reference on the external tasks list?
>
> Regards.
> Alexander Karnstedt
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe@ant.apache.org
> For additional commands, e-mail: dev-help@ant.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@ant.apache.org
For additional commands, e-mail: dev-help@ant.apache.org