oracle.xml.sql.OracleXMLSQLException: Character ')' is not allowed in an XM
446243Aug 14 2005 — edited Feb 27 2020I need to use query-database functionality in transform activity to make a stored function call. My sql query parameter should be
Select CDMB_BPEL_UTILS_PKG.get_coa(null) from dual
Corresponding XML is
?>
<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:ns0="http://www.example.org" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:ldap="http://schemas.oracle.com/xpath/extension/ldap" xmlns:xp20="http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.Xpath20" xmlns:bpws="http://schemas.xmlsoap.org/ws/2003/03/business-process/" xmlns:ora="http://schemas.oracle.com/xpath/extension" xmlns:orcl="http://www.oracle.com/XSL/Transform/java/oracle.tip.pc.services.functions.ExtFunc" exclude-result-prefixes="xsl ns0 xsd ldap xp20 bpws ora orcl">
<xsl:template match="/">
<ns0:OracleRoot>
<ns0:OracleMappedOut>
<ns0:ExpType>
<xsl:value-of select="orcl:query-database('select cdmb_bpel_utils_pkg.get_coa(null) from dual',false(),false(),'eis/JNDI/GDB2')"/>
</ns0:ExpType>
</ns0:OracleMappedOut>
=========But I get the following error when testing the same===========
oracle.xml.sql.OracleXMLSQLException: Character ')' is not allowed in an XML tag name
========================================================
I guess I need to use escape characters to pass ( . I tried using " and ' but in vain. Any help is appreciated to resolve this issue.