Re: bind parameter in existsnode function

On May 16, 10:29 am, ajmastrean <ajmastr..._at_gmail.com> wrote:
> 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"/>

 You stated what you wanted to do but not what the problem is?  What Oracle error are you getting?
 What is the full version of Oracle?
 What tool are you using?

HTH -- Mark D Powell -- Received on Sat May 17 2008 - 21:32:47 CDT