updating more than 2K of data to a LONG datatype Oracle field using Perl/ODBC module
Posted on 1998-08-09
Hello, I am trying to update a datatype LONG field in an Oracle table (can hold 2G of char data), but the SQL UPDATE statement will only allow 2K thru a quoted string (eg UPDATE tickets SET comments = '$body' -- and $body > 2k of data). I have heard something about binding a variable to a database column thru some other mechanism than SQL, but the only examples I have ever seen are thru C call interface. There must be some way to do it with Perls ODBC module for windows 32.