Hi,
I am getting this error message:
DBD::Oracle::st execute failed: ORA-01461: can bind a LONG value only for
insert into a LONG column (DBD ERROR: OCIStmtExecute) at checker.pl line
172.
The code in question has been working fine for a while . I suspect the size
of one of the bind parameters I am passing to the statement is causing the
problem ?
I am inserting into a table with a long column to store text (I thought
65531 was the maximum here)
This is the layout of the handle
my $sth=$dbh->prepare (qq{
INSERT INTO tablename(number,number,date
,number,LONG,number)
SELECT ?,?,sysdate,8,?,0
FROM dual
}) or die "...\n";
I am passing a reference to a long string (length=4243) to a function which
executes that handle thus:
sub MyFunc {
my (VARIOUS_VARIABLES,$bodyref)=@_;
$sth->execute(1,2,$$bodyref); #DIES HERE
}
Any ideas as to what is causing this or better ways of handling this
scenario would be appreciated.
Thanks in advance.
Andy
__________________________
This email and any files transmitted with it are confidential and intended solely for
the use of the individual or entity to whom they are addressed. The contents are
confidential and may be privileged.
Any views or opinions expressed are those of the sender and may not reflect the views
or opinions of the company and the company accepts no liability in respect thereof.
If you have received this email in error please notify [EMAIL PROTECTED]
immediately.
________________________________________________________________________
This e-mail has been scanned for all viruses by Star Internet. The
service is powered by MessageLabs. For more information on a proactive
anti-virus service working around the clock, around the globe, visit:
http://www.star.net.uk
________________________________________________________________________
