for this script utl_file is no longer being used. The problem is that some SQL is over 2499 characters in length, and it may be stored as one line in the data dictionary SQLPlus cannot execute lines ...

This structure is the most basic of all the loop constructs including FOR LOOP and WHILE LOOP. This basic LOOP statement consists of a LOOP keyword, a body of executable code, and the END LOOP ...