Yep its been a forever moment since I last posted something on my blog. Guilty as charged. A lot of things have led to this silence, but I extend my apologies to all who frequently or infrequently pass by my abode.

I do have some things I want to share, so check back soon. Regarding the FTP solution, it continues to survive through and into 11gR2 thus far. It is the primary FTP solution for internal operations within our production environment. I have recv'd numerous emails that speak to other individuals also using within their prod environments. YEAH! As a reminder, due credit goes to a lot of sources... I just took the time to bring it all together to make a more complete solution that was easy to implement. I am confident that it was worth the effort also.

Some things that I would like to add to the FTP process feature wise :

- MPUT and MGET
- I think this should be fairly easy to do by reusing pieces we already have
which are the NLST and the respective PUT / GET routines. Essentially we
retrieve the list of files matching our filespec, then internally iterate
through that list of filenames, pulling them back one by one. The log display
will take some recrafting since it will need to be the full list as well.

- Fix the handling of welcome banners that do not have preceding success codes
on every line. Usually this happens with Windows FTP Services only. The current
workaround is to make the Welcome Banner on the WIN FTP Svc to be a single
continuous line. Obviously, making such a change to the remote WIN FTP Svc is not
always an easy option.

- Fix the wrapper utility package so that it supports the PORT input parameter. Simple
oversight on my part that I left it out.

- Add the LOB support to the wrapper utility as well. Processing of LOBs FTP operations
is faster than the old UTL_FILE read process which is line by line.

- What else would you like to see ??? Send me an email.