LONGs have various restrictions, such as, there can be at most, only one LONG column in a table,....

On the other hand, LOBs do not have such restrictions. After you migrate your LONG tables to use LOBs, you will no longer have these LONG restrictions. You can have multiple LOB columns in a table, and do multiple >4k binds in a single INSERT/UPDATE,...