The below example illustrates how to write a line to a file using UTL_FILE.<\/p>\n
1. Create Directory on your server (ex: Linux, Unix)
\n2. Give writable permissions to the directory created. If you register this code as a concurrent program then you need to make sure your applmgr user has write permissions to this directory.
\n3. Create DIRECTORY object in database using below command. This is different from the physical directory you created in step1.<\/p>\n
You can see the existing directory objects using below query UTL_FILE Write Example: –Open the file in Write mode –Write to the file –Once the writing is done, close the file EXCEPTION<\/p>\n WHEN UTL_FILE.invalid_mode THEN WHEN UTL_FILE.invalid_path THEN WHEN UTL_FILE.invalid_filehandle THEN WHEN UTL_FILE.invalid_operation THEN WHEN UTL_FILE.write_error THEN WHEN UTL_FILE.internal_error THEN WHEN UTL_FILE.charsetmismatch THEN WHEN UTL_FILE.file_open THEN WHEN UTL_FILE.invalid_maxlinesize THEN WHEN UTL_FILE.invalid_filename THEN WHEN UTL_FILE.access_denied THEN WHEN UTL_FILE.invalid_offset THEN WHEN OTHERS THEN END;<\/p>\n","protected":false},"excerpt":{"rendered":" The below example illustrates how to write a line to a file using UTL_FILE. 1. Create Directory on your server (ex: Linux, Unix) 2. Give writable permissions to the directory created. If you register this code as a concurrent program then you need to make sure your applmgr user has write permissions to this directory. […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[518],"tags":[206,207],"class_list":["post-4621","post","type-post","status-publish","format-standard","hentry","category-utl_file","tag-utl_file","tag-write"],"yoast_head":"\n
\nCREATE OR REPLACE DIRECTORY ERPS_OUT_DIR AS '\/home\/haritha'
\n<\/code><\/p>\n
\n
\nselect * from dba_directories;
\n<\/code><\/p>\n
\n
\nDECLARE
\nl_file_handler UTL_FILE.FILE_TYPE;
\nl_txt VARCHAR2(1000) := 'Demo to write to a file using UTL_FILE';
\nl_file_name VARCHAR2(50) := 'ERPSFILE.txt';
\nBEGIN<\/code><\/p>\n
\nl_file_handler := UTL_FILE.FOPEN(‘ERPS_OUT_DIR’,l_file_name,’W’);<\/p>\n
\nUTL_FILE.Put_LINE(l_file_handler,l_txt);<\/p>\n
\nIF UTL_FILE.IS_OPEN(l_file_handler) THEN
\nUTL_FILE.FCLOSE(l_file_handler);
\nEND IF;<\/p>\n
\nraise_application_error (-20051, ‘Invalid Mode Parameter’);<\/p>\n
\nraise_application_error (-20052, ‘Invalid File Location’);<\/p>\n
\nraise_application_error (-20053, ‘Invalid Filehandle’);<\/p>\n
\nraise_application_error (-20054, ‘Invalid Operation’);<\/p>\n
\nraise_application_error (-20055, ‘Write Error’);<\/p>\n
\nraise_application_error (-20057, ‘Internal Error’);<\/p>\n
\nraise_application_error (-20058, ‘Opened With FOPEN_NCHAR But Later I\/O Inconsistent’);<\/p>\n
\nraise_application_error (-20059, ‘File Already Opened’);<\/p>\n
\nraise_application_error (-20060, ‘Line Size Exceeds 32K’);<\/p>\n
\nraise_application_error (-20061, ‘Invalid File Name’);<\/p>\n
\nraise_application_error (-20062, ‘File Access Denied By’);<\/p>\n
\nraise_application_error (-20063, ‘FSEEK Param Less Than 0’);<\/p>\n
\nraise_application_error (-20099, ‘Unknown UTL_FILE Error’||sqlerrm);<\/p>\n