First things firstly : ** IF ** you are using Oracle db version 8.x OR greater , THEN you must STOP the usage of LONGs - plain & simple. LONGs are UN-MANAGEABLE in SQL , implies in performance penalties - mainly because row chaining ...
Anyway : if you want manipulate and/or search LONGs, you must do it in another languages (forget pure SQL), you can do it in PL/SQL (directly using LONG variables if your LONG column < 32 Kb, OR reading by chunks using DBMS_SQL), or pro*c, or Java...

[]s

Chiappa