bind parameter in existsnode function

#1

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

#2

On May 16, 10:29*am, ajmastrean <ajmastr... (AT) gmail (DOT) com> wrote:

Quote:

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

#3

On May 16, 10:29*am, ajmastrean <ajmastr... (AT) gmail (DOT) com> wrote:

Quote:

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

#4

On May 16, 10:29*am, ajmastrean <ajmastr... (AT) gmail (DOT) com> wrote:

Quote:

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

#5

On May 16, 10:29*am, ajmastrean <ajmastr... (AT) gmail (DOT) com> wrote:

Quote:

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

#6

Oops! I got caught up in describing what I was trying to do that I
completely forgot to post the problematic result. When I try to
execute the query above, with the bind value specified above, I get
the following error...

---
An error was encountered performing the requested operation:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00601: Invalid token in: ''//Key[@Value=''True''] and //
Key[@Name=''Validation Status'']''
---

I have also tried removing the surrounding single quotes from the bind
value

---
An error was encountered performing the requested operation:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00601: Invalid token in: '//Key[@Value=''True''] and //
Key[@Name=''Validation Status'']'
---

Installed -- Oracle Data Access Components 10.2.0.2.21
Tool -- Oracle SQL Developer 1.0.0.15

#7

Oops! I got caught up in describing what I was trying to do that I
completely forgot to post the problematic result. When I try to
execute the query above, with the bind value specified above, I get
the following error...

---
An error was encountered performing the requested operation:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00601: Invalid token in: ''//Key[@Value=''True''] and //
Key[@Name=''Validation Status'']''
---

I have also tried removing the surrounding single quotes from the bind
value

---
An error was encountered performing the requested operation:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00601: Invalid token in: '//Key[@Value=''True''] and //
Key[@Name=''Validation Status'']'
---

Installed -- Oracle Data Access Components 10.2.0.2.21
Tool -- Oracle SQL Developer 1.0.0.15

#8

Oops! I got caught up in describing what I was trying to do that I
completely forgot to post the problematic result. When I try to
execute the query above, with the bind value specified above, I get
the following error...

---
An error was encountered performing the requested operation:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00601: Invalid token in: ''//Key[@Value=''True''] and //
Key[@Name=''Validation Status'']''
---

I have also tried removing the surrounding single quotes from the bind
value

---
An error was encountered performing the requested operation:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00601: Invalid token in: '//Key[@Value=''True''] and //
Key[@Name=''Validation Status'']'
---

Installed -- Oracle Data Access Components 10.2.0.2.21
Tool -- Oracle SQL Developer 1.0.0.15

#9

Oops! I got caught up in describing what I was trying to do that I
completely forgot to post the problematic result. When I try to
execute the query above, with the bind value specified above, I get
the following error...

---
An error was encountered performing the requested operation:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00601: Invalid token in: ''//Key[@Value=''True''] and //
Key[@Name=''Validation Status'']''
---

I have also tried removing the surrounding single quotes from the bind
value

---
An error was encountered performing the requested operation:
ORA-31011: XML parsing failed
ORA-19202: Error occurred in XML processing
LPX-00601: Invalid token in: '//Key[@Value=''True''] and //
Key[@Name=''Validation Status'']'
---

Installed -- Oracle Data Access Components 10.2.0.2.21
Tool -- Oracle SQL Developer 1.0.0.15

#10

Got it... the two single quotes around the values in the @Value and
@Name statements are escape characters too. This value

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

may be bound to a parameter just fine.