Re: Converting LONG type to VARCHAR2...

From: Kevin Muhm <muhmkb_at_maritz.com>
Date: 1997/04/10
Message-ID: <01bc45eb$fdb2b5f0$ba1f2d9c@muhmkb>#1/1

The only way to convert LONG to VARCHAR2 is through an assignment - e.g:

	DECLARE
 	   long_var   LONG;
 	   my_var     VARCHAR2(200);  -- make sure to make the VARCHAR big       
                                                   -- enough
	BEGIN
 	   my_var := long_var;

This must be done in PL/SQL - either through a script, PRO-C, stored procedure, etc.

Good luck -

QuadTwin <quadtwin_at_aol.com> wrote in article <19970408022901.WAA04633_at_ladder01.news.aol.com>...
> "TinHa" <kevin_at_tnicholson.com> wrote:
>
> > Hi:
> > Can someone please tell me how can I convert a LONG Datatype to
> > VARCHAR2 ?
>
> I had a similar need. The only solution I found was to write a PRO*C
> program.
> Al Lawson
> Interactive Group, Inc.
> www.interactive-group.com
> lawsona_at_interactive-group.com
>
>
Received on Thu Apr 10 1997 - 00:00:00 CDT