Ant task for Sql scripts


B

Bhavin

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
 
Ad

Advertisements

A

Andy Dingley

Bhavin said:
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!
 
Ad

Advertisements

B

Bhavin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top