LONG to VARCHAR: How can it be done?

From: Thomas Greuter <deletethis.grth1_at_zh.swissptt.ch>
Date: 1997/07/18
Message-ID: <01bc9362$7c5080e0$62d5bb8a@tzhi95>#1/1

Hi2everybody,

I have a view to a table on a SQL-Server using the oracle gateway. The view desc looks as follows:

Name                            Null?    Type
------------------------------- -------- ----
ARTIKEL_ID                      NOT NULL NUMBER(10)
BEZEICHNUNGD                    NOT NULL LONG

BEZEICHNUNGD contains the text I have to put in another table where it is defined as VARCHAR2(255).

Since simple INSERT/UPDATE doesn't work with LONG datatypes, I need some kind of conversion. There is no such thing in PL/SQL as I know. Q: How can this be done? I'm really in trouble, because this is part of a data sync process between two databases.

Every hint is very, very welcome

Thomas
[ENV: ORACLE 7.3, NT4.0, Intel]

[This msg is also posted in newsgroup oracle.sever]
Received on Fri Jul 18 1997 - 00:00:00 CDT