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

John Scoles <[email protected]>
Newsgroups gmane.comp.lang.perl.modules.dbi.general
Message-ID <[email protected]> 
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: [email protected]
> Date: Fri, 30 Mar 2012 15:04:42 -0700
> CC: [email protected]
> To: [email protected]
> 
> 
> 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
> 
>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.