Re: Ant with oracle...

From: Ron <support_at_dbainfopower.com>
Date: Tue, 2 Mar 2004 03:34:22 -0800
Message-ID: <X6udnbKwsIUI8tndRVn-jA@comcast.com>

> Is it possible to use the Ant sql target to compile Oracle 9i stored
> procedure packages? Some of the routines are in java and others are
> standard ddl/dml.
>
> Thanks for any feedback.

Hello schmen,

For a basic approach, You can call sqlplus using Ant's <exec> task, but you'd need to have sql script with the compile statements in place.

If you really need high degree of complexity, you can create custom ant task.

As a reference, O'reilly Ant book is pretty good. Also check this link as well - http://ant.apache.org/manual/develop.html

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html Received on Tue Mar 02 2004 - 05:34:22 CST