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

    SQL Developer script not running all lines

    d4aeea41-ddfa-4b5a-baa2-1de5c4ae49b1

      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