Re: It's a bad day here...

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