Re: LONG to VARCHAR2

From: Michael Krolewski <donotreply_at_interbulletin.bogus>
Date: Fri, 23 Mar 2001 05:50:20 +0000
Message-ID: <3ABAE41C.67841AAC@interbulletin.com>

"André Klos" <andre.klos_at_pikon.com> wrote in article <99d1op$62n$1_at_piesbach.saarnet.de> :
>Hi!
>
>How can I convert LONG to VARCHAR2?
>
>Thanks
>
>André
>
>
>

You question is a bit vague. What are you trying to do? Convert a column in a table or just a local variable.

Assuming that the LONG are long -- beyond 32K, you cannot use PL/SQL as its internal LONG is limited to 32K ( check out the manual). I ran into the same problem -- we had a LONG that needed to be transferred from one table to another.

I found that within C you can write the conversion -- using the C environment to buffer the transfer between the columns.

Michael Krolewski
m_krolewski_at_netzero.net

---

Submitted via WebNewsReader of http://www.interbulletin.com Received on Thu Mar 22 2001 - 23:50:20 CST