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
