> 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.
Sounds like Unix / Windows linefeed character issues. I doubt if it's
Ant's fault, probably SourceSafe is the culprit. Check what you're
actually getting, before you load it into the DB client.
PS - Ditch SourceSafe and go to Subversion. You won't regret it!
Bhavin - 28 Jun 2006 12:22 GMT
Cool, i get the db scripts from vss as
<filename>.spc,<filename>.prc,<filename>.bdy
and i dump these files into database through ant script. I created one
.sql file in my local machine and dumped the file to database through
ant script and it works. i am wondering why its not working with other
files.
-bhavin
> > 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
[quoted text clipped - 8 lines]
>
> PS - Ditch SourceSafe and go to Subversion. You won't regret it!