DSXchange

Posted: **Thu Sep 04, 2008 4:17 am**

Hi,

How to import the oracle table having a column with long data type. The source sysem is already existing system so it could not possible to change data type now. I am getting the following error:

Caught ORCHESTRATE exception in main program: APT_ParseError: Expected identifier; got: <eof>
Could not find type:

Thanks in advance

Regards
Suresh

Posted: **Thu Sep 04, 2008 7:22 am**

An actual LONG, not a CLOB? Yuck. Definitely 'Not Supported' and a PITA to work with even in Oracle. What version of Oracle, btw?

Posted: **Thu Sep 04, 2008 8:52 am**

Hi Chulett,

Oracle 9i

Posted: **Thu Sep 04, 2008 8:54 am**

Hi Chulett,

Oracle 9i

Thanks
Suresh

Posted: **Thu Sep 04, 2008 9:13 am**

Then you *may* be able to use the dbms_lob package to help, talk to your DBA about it.

DSXchange

issue - the Long data type column from oracle table

issue - the Long data type column from oracle table