How about using PL/SQL to load Multimedia LOBs delivered from the web? I have an application that is doing this, and it is working just fine, but requires a commit after EACH file being loaded (because of the SELECT…FOR UPDATE). Fine for a single-user environment – sometimes OK for a 5 user environment – but once I have 100 users uploading files at the same time the COMMITs go through the roof and obviously the frequent commits are not best practice.

I’ve tried SQL*Loader but it’s not consistent enough in such a dynamic environment. PL/SQL is more consistently accurate, but slow as death.