ant-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From <Jan.Mate...@rzf.fin-nrw.de>
Subject AW: New external task: Incanto
Date Tue, 14 Jun 2005 06:32:36 GMT
Fertig! / Done!
Incanto is listed online.

Jan 

>-----Urspr√ľngliche Nachricht-----
>Von: Alexander Karnstedt [mailto:alexander_berlin@gmx.de] 
>Gesendet: Sonntag, 12. Juni 2005 22:39
>An: Ant Developers List
>Cc: Martin Gainty
>Betreff: Re: New external task: Incanto
>
>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
>
>

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


Mime
View raw message