I don't have any insight into your problem but I want to take exception with your assertion that no other commercial products work on Linux. In fact, DB2 works on Linux and has for some time. Here's a link to information about this product: http://www-306.ibm.com/software/data/db2/udb/
If you nose around the IBM site a bit, you should be able to find a free full-function copy of DB2 for Linux. (By free, I mean you don't need a licence for it unless you use it in production. This enables you to get very acquainted with DB2 for free and only buy a licence if you like it enough to use it in production.) Rhino ----- Original Message ----- From: "J. Allen Crider" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 18, 2004 10:54 PM Subject: oracledump.pl error > 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] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]