issue - the Long data type column from oracle table

sureshabbisetti · Post by **sureshabbisetti** » 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

chulett · Post by **chulett** » 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?

sureshabbisetti · Post by **sureshabbisetti** » Thu Sep 04, 2008 8:52 am

Hi Chulett,

Oracle 9i

sureshabbisetti · Post by **sureshabbisetti** » Thu Sep 04, 2008 8:54 am

Hi Chulett,

Oracle 9i

Thanks
Suresh

chulett · Post by **chulett** » 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.