Devart Forums

I have tried to use the UNILOADER to move data from Firebird to Oracle. But if any attribute in Oracle is defined with TIMESTAMP I am unable to do this because my program crashes.

Example of code line that does not work (It does compile):

Sender.PutColumnData(4, i, UniQueryFra.FieldByName('SISTEINNLOGGING').value);

UniQueryFra is the Firebird source and contains a Firebird TIMESTAMP field.
I suspect that the format need to be converted to be accepted by Oracle, and I have
tried a lot of different ways to do this conversion, but I am unable to get it to work.

Note: DirectPath is set to false in Uniloader for Oracle, so ordinary SQL should be used to copy the data.

Could anyone please help me.

Hello

Please provide us with an SQL script for creating the source table in Firebird and destination table in Oracle. It will help us to resolve this issue soon.

/* ---------------------------------------------------------------------- */
/* Add table "HKBRUKER" */
Create in Oracle (SISTEINNLOGGING is the field to look for)

CREATE TABLE HKBRUKER (
BRUKERID VARCHAR2(45) CONSTRAINT NN_HKBRUKER_1 NOT NULL,
FAGPERSNR NUMBER(10),
AVD NUMBER(10),
PROFIL NUMBER(10),
SISTEINNLOGGING TIMESTAMP,
NYTTPASSORDDATO DATE,
STATUS CHAR(1),
DEFP VARCHAR2(45),
CONSTRAINT PK_HKBRUKER PRIMARY KEY (BRUKERID)
);

Create in Firebird

CREATE TABLE HKBRUKER (
BRUKERID VARCHAR(45) NOT NULL,
FAGPERSNR INTEGER,
AVD INTEGER,
PROFIL INTEGER,
SISTEINNLOGGING TIMESTAMP,
NYTTPASSORDDATO DATE,
STATUS CHAR(1),
DEFP VARCHAR(45),
CONSTRAINT PK_HKBRUKER PRIMARY KEY (BRUKERID)
);

Not that different..., a DB tool DBDezign is used to create the scripts.

hello,

Thank you for the information.
We've reproduced the problem.
We will notify you as soon as we have any results.

@AlexP: is this issue fixed with the just released v4.2?
Thanks,
Tobias

hello,

This fix will be included in the next UniDAC version.