Hi,
I need to migrate a Oracle 9i database to PostgreSQL, so I'm using a perl
script ( ora2pg.pl ) and it works fine with Oracle 8i but when I tried to use it
on Oracle 9i It fails .
I tried to updat the DBD::Oracle module to the lastest version but it stills
not working.
I'm usisng a RedHat 9, running perl v5.8.0 built for i386-linux-thread-multi,
DBD::Oracle version 1.14 , DBI version 1.37.
Atached follow the ora2pg.pl, Ora2pg.pm and other files used to run this script.
When I tried to run it targeting a Oracle 9i database it gives me the following
error:
[EMAIL PROTECTED] pgsql]# ./ora2pg.pl
Retrieving table information...
Scanning CCCRMD00 ( VENDAS CCCRMD00 TABLE )...
--CCCRMD00--
DBD::Oracle::st execute failed: ORA-01459: invalid length for variable character
string (DBD ERROR: OCIStmtExecute) [for statement ``SELECT COLUMN_NAME,
DATA_TYPE, DATA_LENGTH, NULLABLE, DATA_DEFAULT
FROM DBA_TAB_COLUMNS
WHERE TABLE_NAME='CCCRMD00'
'' with params: ]) at Ora2Pg.pm line 880.
ORA-01459: invalid length for variable character string (DBD ERROR:
OCIStmtExecute) at Ora2Pg.pm line 880.
What else could I do to make it work ?
Thanx
Rhaoni Chiu Pereira
