Advertisement
Guest User

Untitled

a guest
Dec 15th, 2018
132
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.69 KB | None | 0 0
  1. PROCEDURE TestProcedure (x NUMBER)
  2. AS
  3.    TYPE linearray IS VARRAY(20) OF VARCHAR2(256);
  4.    lines linearray := linearray();
  5.    TIME VARCHAR2(256);
  6.    out_File  UTL_FILE.FILE_TYPE;
  7.    i NUMBER := 0;
  8.    idx NUMBER := 1;
  9. BEGIN
  10.    WHILE idx <= 20
  11.    LOOP
  12.      IF MOD(i,5000000) = 0 THEN
  13.         TIME := TO_CHAR(SYSTIMESTAMP,'yyyy-mm-dd hh24:mi:SS.FF6');
  14.         lines.extend();
  15.         lines(idx) := TIME || ' ' || 'Iteration: ' || TO_CHAR(i);
  16.         idx := idx + 1;
  17.      END IF;
  18.      i := i + 1;
  19.    END LOOP;
  20.    out_File := UTL_FILE.FOPEN('CTEST', 'test_file' || TO_CHAR(x) || '.txt' , 'W');
  21.    FOR i IN 1..(idx-1)
  22.    LOOP
  23.      UTL_FILE.PUT_LINE(out_file, lines(i));
  24.    END LOOP;
  25. END;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement