Re: Executing packages in oracle databae through ant script

Create a mirror copy in VSS of all your SQL scripts that containt your "create pl/sql object" , in a directory X. Run your scripts from that directory.

After running your scripts, compile all invalids objects. Look at %oracle_home%\RDBMS\ADMIN\UTLRP.SQL (on the database server)

Bhavin wrote:
> Hello,
>
> I am working on ant script which dumps the stored procs and packages
> into oracle 9i database. I defined one task in ant script which dumps
> all the scripts from Source safe to oracle database. This works fine
> but when i check into the database i get the packages and stored procs
> with errors. The script dumps all the scripts in a linear way, the
> indentation of the code of PL Sql is lost. I am looking for the
> solution through which i can dump all the scripts with its original
> structure.
>
> do i need to put additional task in database itself so that my scripts
> gets executed in a proper way with its original structure or i need to
> put settings in my Ant script ?
>
> Pls suggest me
Received on Wed Jun 28 2006 - 08:11:53 CDT