Re: AW: New external task: Incanto

2005-06-15 Thread Alexander Karnstedt 

Thanks alot!

Alexander

At 08:32 14.06.2005, you wrote:

Fertig! / Done!
Incanto is listed online.

Jan



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

AW: New external task: Incanto

2005-06-14 Thread Jan.Materne 
Fertig! / Done!
Incanto is listed online.

Jan 

-Ursprüngliche Nachricht-
Von: Alexander Karnstedt [mailto:[EMAIL PROTECTED] 
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/[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]



-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: New external task: Incanto

2005-06-12 Thread Martin Gainty 

Can I execute Oracle Procedures???
Wohlgetan!

Vielen Danke,
Martin-

- Original Message - 
From: Alexander Karnstedt [EMAIL PROTECTED]

To: dev@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:[EMAIL PROTECTED]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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]




-
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Re: New external task: Incanto

2005-06-12 Thread Alexander Karnstedt 

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/[EMAIL PROTECTED] 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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]