On Thu, Nov 15, 2001 at 21:00:16 +0000, Becka Louden wrote:
> Hi, I am new to this newsgroup, so I hope this is not a bad question.
It's a good question, but I thought it was a mailing list :-)
> I trying to use the Perl::DBI to insert a string value into the Oracle
> database. However, I get this error : "ORA-01461: can bind a LONG value
> only for insert into a LONG column (DBD: oexec error) at query_crr.pl line
> 98."
| my $insert_cr = $dbh->prepare( "
| UPDATE crr
| set crr_print_image = ?
| WHERE crr_id = 218936
| "
| );
| $insert_cr->bind_param( 1, $cr, { ora_type => ORA_CLOB } );
Is the table crr that you are accesing perchance a synonym?
If so, try accessing the real table.
-Wolfgang
