SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

compiling packages from command line

793965Feb 24 2011 — edited Feb 24 2011

hi...good morning all...

I want to compile 5 packages from command prompt..

I have written a batch file like this...

d:
call sqlplus -s scott/tiger@ora11g @package1.sql
call sqlplus -s scott/tiger@ora11g @package2.sql
call sqlplus -s scott/tiger@ora11g @package3.sql
call sqlplus -s scott/tiger@ora11g @package4.sql
call sqlplus -s scott/tiger@ora11g @package5.sql
pause
exit

But it is not running...only the package 1 is getting compiled after putting a '/' after the prompt "call sqlplus -s scott/tiger@ora11g @package1.sql"..

But the rest of the packages are not getting compiled..it is not throwing any error also...I have kept the 5 package bodies in the D drive...

Please help..

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 24 2011

Added on Feb 24 2011

8 comments

3,095 views