Re: How to parse long datatypes????

AlexJent wrote:
>
> 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

I've never done it, but I'm fairly certain you could do what you want with dynamic sql and the dbms_sql.column_value_long procedure. See the Oracle Applications Developer's guide for info.

Mike Madland
mikemad_at_asymetrix.com Received on Thu Jan 09 1997 - 00:00:00 CET