Hi Martin,
The value for $dbh->{Statemet} is as follows:
insert into p_dlvrb_study_attributes (dlvrb_gid, study_gid, client_gid,
slsfc_gid, mkt_def_gid, mkt_def_desc, store_panl_gid,
study_anlys_typ_cde, extnd_lkbck_strt_dte, cohrt_strt_dte,
cohrt_end_dte, study_end_dte, lkbck_prd_days_nbr, study_prd_days_nbr,
dlvry_freq_typ_cde, dlvrb_error_flg_desc, std_err_thrhld_nbr,
std_err_ind, actl_dlvry_dte, dlvry_frmt_typ_desc, study_nam,
study_anlys_desc, slsfc_nam, client_long_nam, std_err_rsn_desc,
sob_clsfy_row_cnt, sob_prctr_demo_row_cnt, sob_pay_typ_row_cnt,
sob_sw_dtl_row_cnt, sob_prctr_row_cnt, sob_unq_ptnt_row_cnt,
pc_clsfy_row_cnt, pc_ptnt_demo_row_cnt, pc_prctr_row_cnt,
mkt_cnfgr_gid, itime_prjct_id, client_cntct_nam, dlvrb_nbr) values (?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Thanks.
Peter
--- "Martin J. Evans" <[EMAIL PROTECTED]> wrote:
> Peter Loo wrote:
>
> >Hi,
> >
> >I am trying to pass an array reference to $sth->execute and I am
> >getting the following error:
> >
> >DBD::ODBC::st execute failed: called with 38 bind variables when 0
> are
> >needed at /usr/local/apps/common/devl/bin/GlobalRoutines.pm line 42.
> >
> >The code I am using is as follows:
> >
> > sub sub_executeBind($$$) {
> > local ($dbh, $sth, $bindVar) = @_;
> > $sth->execute(@$bindVar) || die "$dbh::errstr";
> > return($sth);
> > }
> >
> >Will someone please help me understand this error message?
> >
> >Thanks in advance.
> >
> >Peter
> >
> >Peter Loo
> >Worldwide Consulting, Inc.
> >Phoenix, Arizona
> >U.S.A.
> >
> >
> >
> >
> >
> This would suggest there are no parameters in the SQL (i.e. no ? as
> in "insert into table values (?)").
>
> What does $dbh->{Statement}return - it should be the SQL you
> are executuing.
>
> Martin
>
>
>
Peter Loo
Worldwide Consulting, Inc.
Phoenix, Arizona
U.S.A.
