I have just decided to try to learn something about MySQL after several years of working with Oracle and wanted to transfer the data I have in an Oracle 9i database to a new MySQL database. Since this is strictly for personal use, I can't justify the cost of SQLPorter, and none of the other commercial products work on Linux, so I decided to try oracledump.pl. However, I am getting the following error when I attempt to run it:
DBD::Oracle::st execute failed: ORA-01459: invalid length for variable character string (DBD ERROR: OCIStmtExecute) [for statement ``SELECT a.COLUMN_ID,
a.COLUMN_NAME,
a.DATA_TYPE,
a.DATA_LENGTH,
a.DATA_PRECISION,
a.DATA_SCALE,
a.NULLABLE,
a.DATA_DEFAULT,
b.COMMENTS
FROM USER_TAB_COLUMNS a, USER_COL_COMMENTS b
WHERE a.TABLE_NAME = ? AND b.TABLE_NAME = a.TABLE_NAME AND b.COLUMN_NAME = a.COLUMN_NAME'' with params: :p1='ALBUMS']) at ./oracledump.pl line 471.
(followed by several other errors obviously caused by this error.)
Running the same statement in sqlplus works fine.
I am running Oracle 9i Release 2 on Gentoo Linux. Any ideas on what I'm doing wrong?
Wild guess - oracledump.pl has some kind of compatibily issue with your version of Oracle or there is a problem with the Oracle DBD driver. In any case, try debugging it - it is just trying to pull the names of Oracle table columns from the system tables, and is not doing it quite right. I would begin debugging by first making sure the Oracle DBD works ( you should be able to execute a simple Perl script that connects and reads Oracle data).
P.S. Huntsville, AL is a very nice place
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
