Hi Experts,
I work on oracle 11g..
I have a requirement, that I have file on Linux server in a physical location on that Linux server, Oracle DB installed.Using Oracle how can I find out file size using script.
Let me know if any details still required.
I am using below script which i got when i browsing..I have a file located at below path and file is CUSTOMER_20200605.csv when i executed the below i am getting error ...
SQL PLUS Command FAILED - not enough arguments
anonymous block completed
setserveroutput on;
DECLARE
v_fexists BOOLEAN;
v_file_length NUMBER;
v_block_size BINARY_INTEGER;
BEGIN
utl_file.fgetattr
('/usr/oracle/load/files', 'CUSTOMER_20200605.csv', v_fexists, v_file_length, v_block_size);
DBMS_OUTPUT.PUT_LINE (v_file_length);
END;
Thanks,
S
SQLPLUS command failed - not enough argumentsanonymous block completed