oracledump.pl error

[J. Allen Crider]

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?

Allen Crider
Huntsville, AL
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]