Re: long to varchar

From: Ilmar Kerm <ilmar.kerm@xxxxxxxxx>
To: Oracle Freelist <oracle-l@xxxxxxxxxxxxx>
Date: Thu, 27 May 2010 17:49:57 +0300

On Thu, May 27, 2010 at 5:25 PM, Abhishek Gurung
<abhishek.gurung@xxxxxxxxxxx> wrote:
> Hi
>
> I am reading data from MS Access and inserting into oracle.
> I am facing problem with hyperlink datatype of MS access.
> While loading this hyperlink datatype in oracle the oracle is converting it
> into long. I want to insert it into Varchar2 type column but unable to do
> it.

If possible, convert the data type in the MS Access database, for
example create a "Oracle friendly" view on top of the real table that
will do the conversion to varchar and then query the view from Oracle.
I have used this method many times when loading the data from
PostgreSQL to Oracle over HSODBC.

-- 
Ilmar Kerm
--
http://www.freelists.org/webpage/oracle-l

References:

long to varchar
From: Abhishek Gurung

Re: long to varchar

Other related posts: