Please help to resolve below issue.
getting error message while select query of external table to get the list of file names.
---------------------------------
Code:
CREATE TABLE CKYC_FILES_LIST
(
fpermissions VARCHAR2(10),
flink VARCHAR2(2),
fowner VARCHAR2(6),
fgroup VARCHAR2(6),
fsize VARCHAR2(100),
fdate VARCHAR2(100),
fname VARCHAR2(255)
)
ORGANIZATION EXTERNAL
(
TYPE ORACLE_LOADER
DEFAULT DIRECTORY CKYCDATA
ACCESS PARAMETERS
(
records delimited by newline
load when fsize != '0'
preprocessor CKYCDATA:'list_file.sh'
fields terminated by whitespace
(
fpermissions position(1:10),
flink position(12:14),
fowner position(15:21),
fgroup position(22:28),
fsize position(28:37),
fdate position(37:50),
fname position(51:305)
)
)
LOCATION ('list_file.sh')
)
REJECT LIMIT UNLIMITED
/
--CKYCDATA is directory created with path /backup/CKYCDATA
-----------------------------
list_file.sh
Code:
#!/bin/bash^M
cd /backup/CKYCDATA
/bin/ls -l
---------------
getting error.
KUP-04004: error while reading file /backup/CKYCDATA/list_file.sh
KUP-04017: OS message: Error 0
KUP-04017: OS message: error during exec: errno is 13