XML message to stored as a string into an SQL table?

[Former Member]

Hi,

I have a requirement to make a JDBC insert from inside a BPM when a message is received.

However, one of the field(say <xml_source>) passed to the stored procedure should be the received XML message(whole xml document with all tags) as a string.

I am unable to do this right now, because at runtime it treats the contents of <xml_source> as xml tags and it is erroring out.

I have used a work around for the time being by using the [CDATA] in the <xml_source> tag.

This would have a problem if the received message also has a [CDATA] section, because nested [CDATA] sections are not permitted.

Any suggestions on how to acheive this are most welcome.

Thanks & Regards,

Renjith

[udo_martens]

Hi Renijith,

execute 2 XSLs:

<b>first</b>

		
<xsl:for-each select="//xml_source">
 <xsl:value-of select="." disable-output-escaping="yes"/>
</xsl:for-each>    

<b>second</b>

 
<xsl:text disable-output-escaping="yes"><![CDATA[<![CDATA[

]]
>

Regards,

Udo