Main   Products   Offshore Outsourcing   Customers   Partners   ContactUs  
JDBC Databases
  HXTT Access v5.2
  HXTT Cobol v2.1
  HXTT DBF v5.2
  HXTT Excel v4.2
  HXTT Paradox v5.2
  HXTT Text(CSV) v5.2
  HXTT XML v1.2
Offshore Outsourcing
Oracle Data Import/Export
DB2 Data Import/Export
Sybase Data Import/Export
Free Resources
  Firewall Tunneling
  Search Indexing Robot
  Conditional Compilation
  Password Recovery for MS Access
  Password Recovery for Corel Paradox
  Checksum Tool for MD5
  Character Set Converter
  Pyramid - Poker of ZYH
   
   
   
Hongxin Technology & Trade Ltd. of Xiangtan City (abbr, HXTT)

Text2Oracle
motify type of column
HanWang
2008-03-10 19:37:53.0
hi,
when I execute export,error:

Prepare to export :DelayedDataHK-SL-0227.zip.DELAYEDDATAHK-SL --> PF99.DELAYEDDATAHK-SL
java.sql.SQLExceptionORA-01754: a table may contain only one column of type LONG
java.sql.SQLException: ORA-01754: a table may contain only one column of type LONG

but I can not motify type of column,How is it so?

Thinks

motify type of column
HanWang
2008-03-10 19:42:00.0
hi,
when I execute export,error:

Prepare to export :DelayedDataHK-SL-0227.zip.DELAYEDDATAHK-SL --> PF99.DELAYEDDATAHK-SL
java.sql.SQLExceptionORA-01754: a table may contain only one column of type LONG
java.sql.SQLException: ORA-01754: a table may contain only one column of type LONG

but I can not motify type of column,How is it so?

Thinks

Re:Re:motify type of column
HXTT Support
2008-03-11 06:08:24.0
Doesn't the DELAYEDDATAHK-SL table exist in oracle database and need created? It seemed that you assigned or auto map two LONG type column accord you DelayedDataHK-SL-0227.zip.DELAYEDDATAHK-SL table when create the table in oracle database.
You can see here to know how to change the target table column type.

Search Key   Search by Last 50 Questions




Google
 

Address: 9 Station Rd., Xiangtan City, Hunan Province, P.R. China
Postcode: 411100
Phone: (86)731-58225727
Fax: (86)731-58225727
Email: webmaster@hxtt.com
Copyright © 1999-2011 Hongxin Technology & Trade Ltd. | All Rights Reserved. | Privacy | Legal | Sitemap