Pinned topic Executing a dynamic SQL query with a < symbol
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
I am trying to run some dynamic queries generated from a xslt against a Oracle database. I can do this until I introduce a < sign in the query. I have the query externalized to a XML file right now and I get it via the document() function within my XSLT. I wrapped the query in CDATA in the XML and used the < escaped less than. All looks good. When I look in the probe, the query looks right with a < sign. Because DataPower wraps the query in XML, this becomes ivalid on the Oracle side. Oracle returns "ORA-00920: invalid relational operator". I cannot seem to get this escaped in the actual query that DP generates in the XML. If I hard code this query with the < sign in a static SQL action it works fine. Any ideas on how to introduce < in a dynamic query in XSLT? I tried disabling output escaping, wrapping the actual query in CDATA on the outbound side, etc. Any help is appreciated.
Updated on 2013-02-18T14:24:44Z at 2013-02-18T14:24:44Z by JBrennan
JBrennan 270003M2T277 Posts
Re: Executing a dynamic SQL query with a < symbol2013-02-18T14:24:44ZThis is the accepted answer. This is the accepted answer.
- SystemAdmin 110000D4XK