PL-SQL code to write a file

PL-SQL code to write a file
Oracle apps ebs plsql to write a file
how to write a file using plsql

DECLARE
   fHandler   UTL_FILE.FILE_TYPE;
BEGIN
   fHandler := UTL_FILE.FOPEN ('STUDENT_DIR', 'Details.txt', 'w'); ---dir,filename,mode

   UTL_FILE.PUTF (fHandler, 'Name: Amol n');

   UTL_FILE.FCLOSE (fHandler);
EXCEPTION
   WHEN UTL_FILE.invalid_path
   THEN
      raise_application_error (
         -20000,
         'Invalid path. Create directory or set UTL_FILE_DIR.');
END;

Related posts:

• View java class source in oracle database
• Load Java source code in oracle database
• Query to find and remove Oracle database locks
• PL-SQL code to write a file
• PL-SQL code to read a file
• Query to find second and third highest value
• PL-SQL Procedure to send email with attachment
• Query to get the details of the lock in the database
• Query to find Table size

Upload your own post and refer it anywhere anytime: