gt;execute(@params)) {
> die "execute of EXPLAIN failed";
> }
>
> On Mon, Apr 20, 2009 at 2:42 PM, Nelson, Erick [HDS]
> wrote:
>> Instead of a ? as a place holder, try using numeric place holders (eg.
>> :1, :2...etc)
>> Example:
>> Select *
R wrote:
>
>> Date: Mon, 20 Apr 2009 16:26:06 -0500 From: E R To:
>> Johannes Gritsch Cc: "dbi-users@perl.org"
>> Subject: Re: an explain plan for Oracle queries with
>> placeholders
>>
>> Ok - here's another attempt:
>>
>> my $pre
alue of the bind_parameter bound.
Regards,
Michael
On Mon, 20 Apr 2009, E R wrote:
Date: Mon, 20 Apr 2009 16:26:06 -0500 From: E R To:
Johannes Gritsch Cc: "dbi-users@perl.org"
Subject: Re: an explain plan for Oracle queries
with placeholders
Ok - here's another a
epare of EXPLAIN failed";
>> }
>>
>> unless ($esth->execute(@params)) {
>> die "execute of EXPLAIN failed";
>> }
>>
>> On Mon, Apr 20, 2009 at 2:42 PM, Nelson, Erick [HDS]
>> wrote:
>>> Instead of a ? as a place hol
essage-
From: E R [mailto:pc88m...@gmail.com]
Sent: Monday, April 20, 2009 12:25 PM
To: dbi-users@perl.org
Subject: an explain plan for Oracle queries with placeholders
I'd like to perform an EXPLAIN PLAN on a query that has question mark
placeholders.
I've seen perl scripts which perfo
lders (eg.
> :1, :2...etc)
> Example:
> Select * from sfile where id = :1
>
> -Original Message-
> From: E R [mailto:pc88m...@gmail.com]
> Sent: Monday, April 20, 2009 12:25 PM
> To: dbi-users@perl.org
> Subject: an explain plan for Oracle queries with placehold
I'd like to perform an EXPLAIN PLAN on a query that has question mark
placeholders.
I've seen perl scripts which perform EXPLAIN PLAN commands, but the
queries they operate on don't have placeholders.
Any pointers on how I would go about doing this?
Thanks,
ER