Uniloader, oracle and timestamp

[Reier]

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.

[bork]

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.

[Reier]

/* ---------------------------------------------------------------------- */
/* 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.

[AlexP]

hello,

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

[tobias_cd]

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

[AlexP]

hello,

This fix will be included in the next UniDAC version.