Oh man this is embarrassing :-) A sharp-eyed reader pointed out that I was not
doing what I thought I was doing!
"I noticed the following (edited for emphasis):
> foreach $i (@resources){
>$csr_prefapp->execute($i)
>$csr_prefapp->fetchrow())
>if (!$have_pref){
>$csr_allapp->e
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...@pharm
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
On 29/03/12 22:45, Bruce Johnson wrote:
another odd error:
[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.af
> Date: Fri, 30 Mar 2012 09:10:41 +0100
> From: martin.ev...@easysoft.com
> To: john...@pharmacy.arizona.edu
> CC: dbi-users@perl.org
> Subject: Re: Error I've not seen before from oracle DBD
>
> On 30/03/12 09:02, Martin J. Evans wrote:
> > On 29/03/12 22:10, Bruce Johnson wrote:
> >>
> >> On
On 30/03/12 09:02, Martin J. Evans wrote:
On 29/03/12 22:10, Bruce Johnson wrote:
On Mar 29, 2012, at 1:58 PM, Bill Ward wrote:
Try not using numbers for the placeholder names?
That worked...
my $sq_res_pend = "insert into reservations_pend (pid, email, cn,
purpose, reserver_affstring) va
On 29/03/12 22:10, Bruce Johnson wrote:
On Mar 29, 2012, at 1:58 PM, Bill Ward wrote:
Try not using numbers for the placeholder names?
That worked...
my $sq_res_pend = "insert into reservations_pend (pid, email, cn, purpose,
reserver_affstring) values(:A,:B,:C,:D,:E) returning reservation