UTL file Test code

UTL file Test code

-- Test code for Oracle 12c+ (Create file in DBA directory)

mkdir -p /u01/app/oracle/admin/test/dpdump

-- CREATE OR REPLACE DIRECTORY DBA_DIR AS '/u01/app/oracle/admin/test/dpdump';

-- GRANT READ, WRITE ON DIRECTORY DBA_DIR TO apps;

BEGIN

  DECLARE

    file_handle UTL_FILE.FILE_TYPE;

  BEGIN

    file_handle := UTL_FILE.FOPEN('DBA_DIR', 'test_file.txt', 'W');

    UTL_FILE.PUT_LINE(file_handle, 'This is a test file created from PL/SQL.');

    UTL_FILE.PUT_LINE(file_handle, 'Database Version: 12c or higher');

    UTL_FILE.FCLOSE(file_handle);

  END;

END;

/

If oracle ebs test 

exec FND_FILE.PUT_LINE(FND_FILE.LOG, 'THIS IS A TEST');

Please do like and subscribe to my youtube channel: https://www.youtube.com/@foalabs If you like this post please follow,share and comment