How to parse long datatypes????

[Quoted] Has anyone had the need to parse long datatypes (from PL/SQL).

I am able to select longs into a PL/SQL variable declared as VARCHAR2(32767)
and from there use string manipulation functions to do whatever I want but if the long has data greater than 32767 then it is lost.

Has anyone any ideas....I'm brain dead now.

P.S. Please copy any responses the me at work as well as the news group

    jentilucci_at_notes.seagate.com

Thanks....Alex
Alex Jentilucci - Consultant
Information System Dynamics, Inc
Minneapolis, MN 55323
Tele: 612-476-7395 FAX: 612-473-5954

E-Mail Work(Current Client): jentilucci_at_notes.seagate.com

                           Business: infosys_at_aol.com
                                Home: AlexJent_at_aol.com