Monday 30 March 2020

How to Copy files from one directory to other in plsql

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