Ant task for database script
- From: "Bhavin" <bhavin.vyas@xxxxxxxxx>
- Date: 30 Jun 2006 04:28:01 -0700
Hello,
Has anybody worked on ant script for executing the database scripts. I
am working on build process and in which the sql command is working
fine for simple packages and stored procs. I am working on
interdependency of packages. My ant script fetches the database scripts
checked in visual source safe for oracle 9i. At the runtime i have to
check the interdependency. The dependency of package related stored
proc is described below.
There are two packages in oracle - A & B
Few Stored Procs in Package A are dependent / calling Stored Procs in
Package B and vise a versa, in this case the precedence of Package
needs to be set.
This senario comes in when getting scripts from VSS. Ant runs all the
files one by one thus unpredictable that when Package A will be
executed and when Package B will be executed.
Any input / suggestion to this senario will be greatly appreciated.
.
- Follow-Ups:
- Re: Ant task for database script
- From: Andy Dingley <dingbat@xxxxxxxxxxxxxx>
- Re: Ant task for database script
- Prev by Date: Encoding conversion from UTF to ISO-8859-7
- Next by Date: browser reload button and Applet
- Previous by thread: Encoding conversion from UTF to ISO-8859-7
- Next by thread: Re: Ant task for database script
- Index(es):