Are you selecting Lobs or Blobs??
Could be an issue. Crank up the ora_verbse to 15 to get everything.
It would do an extra select to get any lob types.
I will have to have a look at the full thread sometime tomorrow.
Cheers
John
> Subject: Re: It's a bad day here...
> From: john...@pharmacy.arizona.edu
> Date: Fri, 30 Mar 2012 15:04:42 -0700
> CC: dbi-users@perl.org
> To: martin.ev...@easysoft.com
>
>
> On Mar 30, 2012, at 5:38 AM, Martin J. Evans wrote:
>
> > So, as far as DBD::Oracle is concerned the statement handle is not active.
> >
> > Perhaps setting ora_verbose before your code above and turning it off
> > afterwards would help us see what is really happening.
>
> Well, I've got a ton of output but not really enlightened any more:
>
> I did the following:
>
> $lda->{ora_verbose} =6;
> foreach $i (@resources){
> $have_pref=0;
> $csr_prefapp->execute($i) or die $DBI::errstr;
> while (($k, $j) = $csr_prefapp->fetchrow()){$approvers{$k}=$j;$have_pref=1;}
> if (!$have_pref){
> $csr_allapp->execute($i) or die $DBI::errstr;
> while (($k, $j) = $csr_prefapp->fetchrow()){$approvers{$k}=$j;}
> }
> }
> $lda->{ora_verbose} =1;
>
> And got the following output, in which everything is a success up until the
> final message, if I read this correctly.
>
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] dbd_bind_ph(1):
> bind :p1 <== '120' (type 0 (DEFAULT (varchar)), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] ), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] dbd_rebind_ph()
> (1): rebinding :p1 as '120' (not-utf8, ftype 1 (VARCHAR), csid 0, csform
> 0(0), inout 0), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> dbd_rebind_ph_char() (1): bind :p1 <== '120' (, referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] size 3/8/0, ,
> referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] ptype 8(VARCHAR),
> otype 1 ), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> dbd_rebind_ph_char() (2): bind :p1 <== ''12' (size 3/8, otype 1(VARCHAR),
> indp 0, at_exec 1), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] \t bind :p1 as
> ftype 1 (VARCHAR), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \tOCIBindByName(1ac0678,19dc6d8,1996df0,":p1",placeh_len=3,value_p=1ab01f0,value_sz=8,dty=1,indp=19dc6f8,alenp=0,rcodep=19dc6f0,maxarr_len=0,curelep=0
> (*=0),mode=DATA_AT_EXEC,2)=SUCCESS, referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \tOCIBindDynamic(1ac02f8,1996df0,19dc6a0,7f3aca306120,19dc6a0,7f3aca306410)=SUCCESS,
> referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \tOCIAttrGet(1ac02f8,OCI_HTYPE_BIND,19dc6bc,0,31,1996df0)=SUCCESS, referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] dbd_rebind_ph():
> bind :p1 <== '120' (in, not-utf8, csid 1->0->1, ftype 1 (VARCHAR), csform
> 0(0)->0(0), maxlen 8, maxdata_size 0), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \tOCIAttrSet(1ac02f8,OCI_HTYPE_BIND, 7fff1105787c,0,Attr=31,1996df0)=SUCCESS,
> referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] dbd_st_execute
> SELECT (out0, lob0)..., referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] Statement Execute
> Mode is 0 (DEFAULT), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] \t\tin ':p1'
> [0,0]: len 3, ind 0, value='120', referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \tOCIStmtExecute(1996d10,1ac0678,1996df0,0,0,0,0,mode=DEFAULT,0)=SUCCESS,
> referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \trs_array_init:imp_sth->rs_array_size=158, rs_array_idx=0, prefetch_rows=0,
> rs_array_status=SUCCESS, referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \tOCIAttrGet(1ac0678,OCI_HTYPE_STMT,7fff11057a0e,0,OCI_ATTR_SQLFNCODE,1996df0)=SUCCESS,
> referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] \tdbd_st_execute
> SELECT returned (SUCCESS, rpc0, fn4, out0), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] \tdbd_st_fetch 2
> fields..., referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \tOCIStmtFetch(1ac0678,1996df0,158,2,0)=NO_DATA, referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \tOCIAttrGet(1ac0678,OCI_HTYPE_STMT,1abf21c,0,OCI_ATTR_ROWS_FETCHED,1996df0)=SUCCESS,
> referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] ...Fetched 0 rows,
> referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] \tdbd_st_fetch
> no-more-data, fetch count=0, referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] dbd_bind_ph(1):
> bind :p1 <== '120' (type 0 (DEFAULT (varchar))), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] dbd_rebind_ph()
> (1): rebinding :p1 as '120' (not-utf8, ftype 1 (VARCHAR), csid 0, csform
> 0(0), inout 0), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> dbd_rebind_ph_char() (1): bind :p1 <== '120' (size 3/8/0, ptype 8(VARCHAR),
> otype 1 ), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> dbd_rebind_ph_char() (2): bind :p1 <== ''12' (size 3/8, otype 1(VARCHAR),
> indp 0, at_exec 1), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] \t bind :p1 as
> ftype 1 (VARCHAR), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \tOCIBindByName(1acb168,1aca728,1996df0,":p1",placeh_len=3,value_p=19fd3d0,value_sz=8,dty=1,indp=1aca748,alenp=0,rcodep=1aca740,maxarr_len=0,curelep=0
> (*=0),mode=DATA_AT_EXEC,2)=SUCCESS, referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \tOCIBindDynamic(1acae58,1996df0,1aca6f0,7f3aca306120,1aca6f0,7f3aca306410)=SUCCESS,
> referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \tOCIAttrGet(1acae58,OCI_HTYPE_BIND,1aca70c,0,31,1996df0)=SUCCESS, referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] dbd_rebind_ph():
> bind :p1 <== '120' (in, not-utf8, csid 1->0->1, ftype 1 (VARCHAR), csform
> 0(0)->0(0), maxlen 8, maxdata_size 0), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \tOCIAttrSet(1acae58,OCI_HTYPE_BIND, 7fff1105787c,0,Attr=31,1996df0)=SUCCESS,
> referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] dbd_st_execute
> SELECT (out0, lob0)..., referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] Statement Execute
> Mode is 0 (DEFAULT), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] \t\tin ':p1'
> [0,0]: len 3, ind 0, value='120', referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \tOCIStmtExecute(1996d10,1acb168,1996df0,0,0,0,0,mode=DEFAULT,0)=SUCCESS,
> referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \trs_array_init:imp_sth->rs_array_size=158, rs_array_idx=0, prefetch_rows=0,
> rs_array_status=SUCCESS, referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237]
> \tOCIAttrGet(1acb168,OCI_HTYPE_STMT,7fff11057a0e,0,OCI_ATTR_SQLFNCODE,1996df0)=SUCCESS,
> referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] \tdbd_st_execute
> SELECT returned (SUCCESS, rpc0, fn4, out0), referer:
> https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
> [Fri Mar 30 14:19:25 2012] [error] [client 128.196.45.237] DBD::Oracle::st
> fetchrow failed: ERROR no statement executing (perhaps you need to call
> execute first) [for Statement "select distinct a.cn, a.email from admins a,
> resourceadminaffil r, resources r2, adminaffil a2, affils a3 where a.pid =
> r.pid and r.resource_id = r2.resource_id and a.pid = a2.pid and a2.affil_id =
> a3.affil_id and a3.affil_code in ('1901','PHRM') and r2.resource_id =?" with
> ParamValues: :p1='120'] at /home/allwebfiles/perl/reserve2.pl line 124.,
> referer: https://resource-scheduler.pharmacy.arizona.edu/calendar/reserve.pl
>
>
>
> --
> Bruce Johnson
> University of Arizona
> College of Pharmacy
> Information Technology Group
>
> Institutions do not have opinions, merely customs
>
>
