Length of a LONG value
571956Aug 11 2009 — edited Aug 12 2009What is the easiest way to determine the length of the value in a given LONG column? I am working on converting some tables in my database that still use the LONG column to be CLOB or VARCHAR2...haven't decided yet.
I've found a function that converts it to VARCHAR2 and returns that value. But VARCHAR2 only goes up to 32767, so I'd like to know if the value in the LONG column is larger than that, but the LENGTH() function doesn't work.
Thanks for anyone's help,
ivalum21