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>
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