Re: changing charakters in long-datatypes

From: Alan <alanshein_at_spambuster.erols.com>
Date: Mon, 23 Oct 2000 09:16:59 -0400
Message-ID: <8t1do2$7u9$1@bob.news.rcn.net>

You can't do any string manipulations on a Long.

"kacetl harald" <harald.kacetl_at_alcatel.at> wrote in message news:39F4321D.F9F1901D_at_alcatel.at...
> hi,
>
> i want to change some charakters in a entity (e.g. replace all chr(13)
> with chr(10)) which is of type long. but for that type, functions like
> REPLACE, SUBSTR, ... don't work.
> can someone help me on this issues.
> notice, that this has to be done directly in oracle with without using
> selfwritten functions or even a script (pl/sql, c, perl, ...)
>
> regards, harald
>
>
Received on Mon Oct 23 2000 - 08:16:59 CDT