Passing XML as a parameter to Oracle or SQL

In some cases we need to pass whole XML as a parameter to stored procedure in Oracle or SQL The issue is you cannot write XML as XML element XML will be broken The solution is pretty simple 1. Create a BizTalk project 2. Create new orchestration 3. Create new message InputXML and set type to System.Xml.XmlDocument 4. Create Receive shape assign InputXML to it as Message 5. Create Receive Port which will be assigned to file receive port in BizTalk applicatoin 6. Connect Receive Port with Receive shape 7. Create new Schema name it SQLParams It should look like XMLParam is the element which will hold our XML 8. Add new Message to orchestration name it Transformed , set type to SQLParams 9. Add variable Doc to orchestration , set type System.Xml.XmlDocument 10. Insert to orchestration Message Construct shape 11. Insert to Message Construct shape Message assignment shape name it Transformation 12. Edit Transformation , set expression Doc.LoadXml(@" <ns0:Root x