Re: Error I've not seen before from oracle DBD

On Mar 29, 2012, at 1:58 PM, Bill Ward wrote:

> Try not using numbers for the placeholder names?
> 

That worked...

my $sq_res_pend = "insert into reservations_pend (pid, email, cn, purpose, reserver_affstring) values(:A,:B,:C,:D,:E) returning reservations_pend_id into :NEWID";

my $csr_res_pend = $lda->prepare($sq_res_pend) or die $DBI::errstr;
$csr_res_pend->bind_param(':A',$res_pid) or die $DBI::errstr;
$csr_res_pend->bind_param(':B',$res_email) or die $DBI::errstr;
$csr_res_pend->bind_param(':C',$res_name) or die $DBI::errstr;
$csr_res_pend->bind_param(':D',$res_purp) or die $DBI::errstr;
$csr_res_pend->bind_param(':E',$res_affil) or die $DBI::errstr;
$csr_res_pend->bind_param_inout(":NEWID",\$new_res_id, 25) or die $DBI::errstr;

$csr_res_pend->execute();

Got right through.

Is this a bug or a rule I'm not aware of? 


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

Institutions do not have opinions, merely customs