Odd error using bind_param_inout

I'm getting the following error:

[Mon Jun 04 09:14:49 2012] [error] [client 128.196.45.237] DBD::Oracle::db do failed: ORA-01008: not all variables bound (DBD ERROR: OCIStmtExecute) [for Statement "insert into resources ( short_name,long_name,building_id,room_desc,isaroom,numseats,numtables,hour_open,hour_close,available,computer,enet_num,approved_text)values( 'B340','SP Training Room','1062','','1','','','7','20','A','','','') returning resource_id into :new_id"] at /home/allwebfiles/perl/resource_mgmt2.pl line 67., referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/resource_mgmt.pl


The relevant perl code is:

my $new_resource_id = 0;
my $csr_insert = $lda->do($sq_insert);
$csr_insert->bind_param_inout(':new_id', \$new_resource_id, 25);
$csr_insert->execute();

There's only one variable, and as far as I can see it's correct.

$sq_insert is the statement listed in the logged error. resource_id is created via an 'on insert' trigger.


-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs