Hi chaps,
I use as originating machine a DEC Alpha with OpenVMS 6.2,
Ingres6.4/05(axp.vms/03) and patch 4129, and Replicator 1.1/00 (axp.vms/00).
As target machine I use and HP-UX with HP-UX 10.20, with Ingres/NET
6.4/06,Ingres Gateway to Oracle 1.0/00. The point is that when I create a
table in Ingres with a field having date data type, and the same in Oracle
and trying to replicate data through Gateway, I receive the following error
message: source::sgateway server 2: Error -- 25-SEP-1998 17:41:16 -- 1134 -
- D_INSERT: DBMS error inserting record database no 10, tra nsaction_id
-1959185685, sequence 1 into target database 2 0 on table armand1. -- 40206
-- ORA-01830: date format pict ure ends before converting entire input str
source::sgateway server 2: Debug -- 25-SEP-1998 17:41:17 -- 1289 - -
MAILLIST: Mailing source::sgateway server 2: Error -- 25-SEP-1998 17:41:16
-- 1134 - - D_INSERT: DBMS e rror inserting record database no 10, tra
nsactio n_id -1959185685, sequence 1 into target database 2 0 on table
armand1. -- 40206 -- ORA-01830: dat e format pict ure ends before converting
entire i nput str . source::sgateway server 2: Debug -- 25-SEP-1998 17:41:17
-- 1292 - - SSESSION: current session mismatch: ingres says 1, glob al says
3 In the Gateway documentation is written that data conversion for date data
type fields is OK. So? What about the money data type? Is there any way of
getting round this problem?
Any input is wellcome.
Thanks in advance.
Cheers
Armand Pirvu - CA-Ingres Senior DBA
Tel: +40-(0)1-302-1790
GSM: +40-(0)92-294-656