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


Reply via email to