Migration from DB2 to ORACLE

[sezgin]

Hi all!!!

I'm trying to migrate DB2 database to Oracle, but I get into trouble with oracle blob fields. I'm using Oracle 8i and a Delphi client which retrieve the data from DB2 database and post them to Oracle.

I have a DB2 table with folowing structure

CREATE TABLE KBT31B.ANJVAOBJ (
SRCID DECIMAL(18, 0) NOT NULL,
PKGID DECIMAL(18, 0) NOT NULL,
NAME "LONG VARCHAR" NOT NULL,
PATH "LONG VARCHAR" NOT NULL
)

In Oracle documentation is recommended to convert DB2 LONG VARCHAR(n) type to Oracle long. But oracle long type have some restrictions.
A table cannot contain more than one LONG column.
Therefore I change second one Long field to Blob. This is Oracle definition for table:

CREATE TABLE ANJVAOBJ
(SRCID NUMBER(38) NOT NULL,
PKGID NUMBER(38) NOT NULL,
NAME LONG NOT NULL,
PATH BLOB NOT NULL)

So problem is recieved error ORA-01465: invalid hex number.
All comment will be estimate highly!!!

Thanks in advance!!!

[tycho]

CREATE TABLE ANJVAOBJ
(SRCID NUMBER(38) NOT NULL,
PKGID NUMBER(38) NOT NULL,
NAME CLOB NOT NULL,
PATH CLOB NULL);

[sezgin]

Thanks tycho!

This work

Means this that all LONG VARCHAR fields in DB2 database must be declared in Oracle as CLOB?