Is this procedure is onetime situation or you need to automate this procedure as part of your project.

First case, you can ftp the file to the location you wanted and do load from there.

Later case you might need to automate it using some stored procedures and calling sql*ldr, keeping the file in utl_file_dir location. Iam not good in PL/SQL, Just its idea to my level of PL/SQL knowledge. I could be even wrong. Thought of mentioning it, hoping it throw some light on PL/SQL experts.