Funny, you are right it does not look incorrect
give this a quick try
$csr_insert->bind_param_inout(':new_id', \my $new_resource_id, 99);
Was this working before?
Did it break after an upgrade or something??
cheers
John
> ----------------------------------------
> From: john...@pharmacy.arizona.edu
> Subject: Odd error using bind_param_inout
> Date: Mon, 4 Jun 2012 11:01:29 -0700
> To: dbi-users@perl.org
>
> 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
>
>
