From: [EMAIL PROTECTED] > We are having a problem. Any help would be appreciated. > > 1: We are running Perl on NT. > 2: Perl is reading lines of code from a file, concatonating it in a > variable, > and writing to an Oracle database. > 3: I keep on getting a message: > DBD::ODBC::st excute failed: [Microsoft][ODBC driver for > Oracle][Oracle]ORA-01461::can bind a LONG value only for insert > into a LONG column (SQL-22001) [Microsoft][ODBC driver for Oracle] > Error in Parameter 2: Data truncated <SQL-01004> (DBD: > st_execute/SQLExecute err=-1) > > > The execute usualy works fine. The variable is much less than the 32K > limit in the database. Any question, suggestions?
Without seeing some of the actual code we can't do much. I just wonder ... varchar columns can be up to 32K in Oracle? I don't think so. I guess you try to pass too much data for a varchar so the Oracle driver tries to "promote" it into some LONG type but that type cannot be used on that place. But this is just a guess! Jenda ===== [EMAIL PROTECTED] === http://Jenda.Krynicky.cz ===== When it comes to wine, women and song, wizards are allowed to get drunk and croon as much as they like. -- Terry Pratchett in Sourcery -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
