bind parameter in existsnode function

From: ajmastrean <ajmastrean_at_gmail.com>
Date: Fri, 16 May 2008 07:29:21 -0700 (PDT)
Message-ID: <20d9a3e5-a320-4d32-822e-ba3069f9bdcc@f36g2000hsa.googlegroups.com>


I am trying to bind a parameter as the parameter to the existsnode() function.

     select extract(trans_details,'/Transaction/Details/ Key').getStringVal()

     from transaction_audit
     where existsnode(trans_details, :xml_value) = 1

the value I want to pass in (and that works when used in-line) is

     '//Key[@Value=''True''] and //Key[@Name=''Validation Status'']'

the xml snippet that exists inside the trans_details column is

     <Key Name="Validation Status" Value="True"/><Key Name="Authentication Status" Value="False"/> Received on Fri May 16 2008 - 09:29:21 CDT

Original text of this message