This discussion is archived
9 Replies Latest reply: Nov 8, 2013 1:35 PM by d4aeea41-ddfa-4b5a-baa2-1de5c4ae49b1 RSS

SQL Developer script not running all lines

d4aeea41-ddfa-4b5a-baa2-1de5c4ae49b1 Newbie
Currently Being Moderated

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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points