> 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
Hmmm, it seems Oracle can only bind a value that fits the LONG data type definition
into a LONG column type
I'm not an Oracle person but when I have a mysql query that won't run I always:
1) print the offending data to the screen-
2) Is that data a LONG value?
3) Is the column it's trying to put it in a LONG column?
4) Print the whole query to the screen and run it from the command line
( the actual query it's trying, not what you think it's supposed to be
trying)
perhaps there's an error elsewhere in the query that makes it seem
like your puttinga certain type of data
into the wrong type of 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?
After you veryify that 100% with 1-3 do #4
HTH
DMuey
>
> Thank you
>
> --
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
