by Mark D Powell <Mark.Powell@[EMAIL PROTECTED]
>
May 17, 2008 at 07:32 PM
On May 16, 10:29=A0am, ajmastrean <ajmastr...@[EMAIL PROTECTED]
> wrote:
> I am trying to bind a parameter as the parameter to the existsnode()
> function.
>
> =A0 =A0 =A0select extract(trans_details,'/Transaction/Details/
> Key').getStringVal()
> =A0 =A0 =A0from transaction_audit
> =A0 =A0 =A0where existsnode(trans_details, :xml_value) =3D 1
>
> the value I want to pass in (and that works when used in-line) is
>
> =A0 =A0 =A0'//Key[@[EMAIL PROTECTED]
''True''] and //Key[@[EMAIL PROTECTED]
''Validation
Status=
'']'
>
> the xml snippet that exists inside the trans_details column is
>
> =A0 =A0 =A0<Key Name=3D"Validation Status" Value=3D"True"/><Key
> Name=3D"Authentication Status" Value=3D"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 --
