Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Oracle Miscellaneous > bind parameter ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 6899 of 7280
Post > Topic >>

bind parameter in existsnode function

by ajmastrean <ajmastrean@[EMAIL PROTECTED] > May 16, 2008 at 07:29 AM

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[@[EMAIL PROTECTED]
''True''] and //Key[@[EMAIL PROTECTED]
''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"/>
 




 4 Posts in Topic:
bind parameter in existsnode function
ajmastrean <ajmastrean  2008-05-16 07:29:21 
Re: bind parameter in existsnode function
Mark D Powell <Mark.Po  2008-05-17 19:32:47 
Re: bind parameter in existsnode function
ajmastrean <ajmastrean  2008-05-19 09:39:50 
Re: bind parameter in existsnode function
ajmastrean <ajmastrean  2008-06-17 08:35:51 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Wed Dec 3 0:19:04 CST 2008.