Home » Infrastructure » Unix » compiling a list of pkgs in a directory
compiling a list of pkgs in a directory [message #277911] Thu, 01 November 2007 03:20 Go to next message
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
Re: compiling a list of pkgs in a directory [message #277920 is a reply to message #277911] Thu, 01 November 2007 04:00 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
sqlplus userid/pwd@sid @x.pls <<EOF
exit
EOF
sqlplus userid/pwd@sid @y.pls <<EOF
exit
EOF
sqlplus userid/pwd@sid @z.pls <<EOF
exit
EOF

Regards
Michel

Previous Topic: File Not Found Error
Next Topic: Variables from SQLPLUS to UNIX
Goto Forum:
  


Current Time: Sat Dec 03 22:34:30 CST 2016

Total time taken to generate the page: 0.10005 seconds