Re: an explain plan for Oracle queries with placeholders

2009-04-21 Thread Johannes Gritsch
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 *

Re: an explain plan for Oracle queries with placeholders

2009-04-20 Thread E R
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

Re: an explain plan for Oracle queries with placeholders

2009-04-20 Thread Mike Nhan
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

Re: an explain plan for Oracle queries with placeholders

2009-04-20 Thread E R
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

Re: an explain plan for Oracle queries with placeholders

2009-04-20 Thread Steve Baldwin
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

Re: an explain plan for Oracle queries with placeholders

2009-04-20 Thread E R
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

an explain plan for Oracle queries with placeholders

2009-04-20 Thread E R
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