What I "really" want is to transcribe a SQL statement that uses ? placeholders into one that uses :val placeholders (for use with EXPLAIN PLAN.)
So I need to have something that will tell me that the ? at character position X is/is not a real placeholder, etc. I'm guessing that there's nothing in DBD::Oracle which will do that for me. On Mon, Apr 20, 2009 at 5:14 PM, Douglas Wilson <[email protected]> wrote: > On Mon, Apr 20, 2009 at 2:56 PM, E R <[email protected]> wrote: >> I've got tons of sql that uses ? placeholders. >> >> Is there a way to accurately determine which question marks represent >> placeholders and which ones don't? > > I don't know if this is "really" what you need or not, but there is > a NUM_OF_PARAMS statement handle attribute that'll tell you how many > placeholders are in the statement. > > HTH, > Douglas Wilson >
