Re: Converting a Long datatype to Varchar2

Hello,
This routine solves my problems with long/varchar2:

Regards,
Erik

CREATE OR REPLACE
Function Long2Char(lngVal IN LONG) RETURN VARCHAR2 IS lngResult VARCHAR2(2000);
Begin
  lngResult := lngVal;
  Return (lngResult);
End;

ejao_at_yahoo.com wrote:

> I am trying to do an Insert-Select sql statement with one of the fields
> being a Long datatype. I know that this will give me an "Illegal use
> of Long Datatype" error. Is there any other way of doing the same
> thing without actually going through a cursor and looping through the
> recordset?
>
> Appreciate the help and thanks in advance,
> Ed Jao
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.

Received on Mon Sep 13 1999 - 08:29:42 CDT