1. Create directory SSS_UTL_DIR
CREATE DIRECTORY SSS_UTL_DIR AS '/var/tmp/LR12TST2';
2. check directory in dba_directories
select * from dba_directories
where directory_name in ('SSS_UTL_DIR')
3. run below script to copy the file in the same directory.
DECLARE
v_file VARCHAR2(100):='HR_SSS_03032020064038_Copy.xml';
BEGIN
Utl_File.Fcopy('SSS_UTL_DIR','HR_SSS_03032020064038.xml','SSS_UTL_DIR',v_file);
END;
No comments:
Post a Comment