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]
