Cant find UTL_FILE_DIR
Hi there,
I faced problem to write to text file with stored procedure.
I can't find the init file in my computer to check my UTL_FILE_DIR path.
my coding is as below:
/*****************************************************
CREATE OR REPLACE PROCEDURE sp_write_file
AS -- STANDARD VARIABLE FOR EXCEPTION LOGGING
write_txtfile_id UTL_FILE.FILE_TYPE;
BEGIN
write_txtfile_id := UTL_FILE.fopen('C:\Oracle\Oracle81\bin','sa.txt','w');
UTL_FILE.PUT_LINE(write_txtfile_id,'hello');
UTL_FILE.fclose(write_txtfile_id);
END;
/
*****************************************************/
Can you help me out in figuring out the way to create and write to text file?
Thank you so much.