Using PLSQLDev and building database on Unix

[kctx7]

Our Oracle servers run on Unix systems, and we do our QA and productions builds of our web, java, and database code all on the Unix (linux) systems.

We check in all of our pl/sql, tables, views, etc. from PLSQL Developer into CVS, and the build pulls them from CVS.

We use SQL*Plus on the unix side to execute each of the various "create or replace" scripts written by PLSQL Developer. SQL*Plus is VERY PROBLEMATIC. Anyone doing something similar, but with a different solution on the unix side?

We've also tried ANT for our database builds, with very limited success.

Both ANT and SQL*Plus have issues with SEMICOLONS and SLASHES and general line termination kinds of things. We currently have to add or remove semicolons in various places, after PLSQL Developer saves the file, to please SQL*Plus. There's got to be a better way.

Another problem with using SQL*Plus for database builds: despite setting "whenever sqlerror exit", sql*plus actually won't die on simple syntax errors if a script is just wrong. It only stops on ORA- type errors returned from Oracle.

Any suggestions or ideas are welcome.

 

[oraclelover]

I feel your pain.
I'm a developer and we run Oracle on Unix boxes as well. We have dev boxes system integration boxes, qa, and than of course production. The only place I'm allowed to compile is under my dev schema and under a master schema on dev. All the other compiles are done by me sending DBAs my script for compilation. The DBAs all use SQL PLUS 9.2.x something now and slashes and spaces and other things have cause my perfectly correct package to fail compilation when the DBA gets a hold of it. So now I have to log int the unix box where we have sql plus 9.2.x something to make sure they won't get an error causing me to check my source out of version manager make the changes resend the reqeust blah blah blah. On my pc where I use pl/sql developer I have and older version of sql plus and it compiles my code fine it seems to be the 9.x series that has issues.