| compiling a list of pkgs in a directory [message #277911] |
Thu, 01 November 2007 03:20  |
vejayara
Messages: 1
Registered: November 2007
|
Junior Member |
|
|
hi,
I have a directory with a list of pkgs. I want to compile all of them against a db/schema in one go. I am not allowed to modify the pkgs in the directory with any commands (exit statements or otherwise). The pkgs currently have whenever sqlerror exit failure rollback in them. The pkgs also contain an exit statement in the end.
The problem is that if i do a simple stuff like having a file with the following,
sqlplus userid/pwd@sid @x.pls
sqlplus userid/pwd@sid @y.pls
sqlplus userid/pwd@sid @z.pls
it goes thru each of the files as far as each of the pkgs compiles successfully. The moment one of the pkgs in the list fails, the sql returns
Warning: Package Body created with compilation errors.
and the cursor is retained in sql.
I tried creating a file with
sqlplus userid/pwd@sid @x.pls
exit
sqlplus userid/pwd@sid @y.pls
exit
sqlplus userid/pwd@sid @z.pls
exit
Even then when the pkgs have errors, the cursor, prompt, stays in sql. I have to do an explicit "enter" and only then the exit command takes effect.
Can anyone provide a simple w/a or suggestion.
Thanks in advance
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
