Odi's astoundingly incomplete notes
New entries | CodeOracle: convert LONG to VARCHAR
Seems hard, but is simple (at least with 10g):
mystring := substr(mylong, 1);With older Oracle versions your milage may vary.
Todd Brook