Skip to Main Content

SQL Developer

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!

SQL Developer script not running all lines

1052700Nov 5 2013 — edited Nov 8 2013

I have a group of scripts that I want to run in sequence from a master script.  I have created a file referencing those scripts as follows below.  My problem is that when I run this script (using either F5 or another script referencing this one), it only runs the first line and stops.  I have ruled out issues with my file references by changing the order - it always runs the first one and stops.  I have tried as displayed below as well as using a semi-colon ; to separate each command.  I have scoured the web and can't find any reason why this isn't working.  Each of the scripts referenced below contains multiple statements separated with a ; that spools a file to a NAS where it is picked up by our external file transfer program.  All of that works correctly - the only thing I'm having issues with is using 1 script to call multiple files and execute them in sequence.

Any help is greatly appreciated!!

@@EMSTATUS.sql

@@EMPLOYEE.sql

@@HREMPUSF.sql

@@HRHISTORY.sql

@@HRSUPER.sql

@@JOBCLASS.sql

@@JOBCODE.sql

@@PAACTREAS.sql

@@PAEMPLOYEE.sql

@@PAEMPPOS.sql

@@PCODES.sql

@@PCODESDTL.sql

@@PERSACTHST.sql

@@PRDISTRIB.sql

@@PRPAYCODE.sql

@@PSGRELATE.sql

@@REVIEW.sql

This post has been answered by Turloch O'Tierney-Oracle on Nov 8 2013
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 6 2013
Added on Nov 5 2013
9 comments
1,964 views