Hi, can I Use Xml as parameter to stored procedure and parse xml inside the procedure? . your idea is greatly appreciated..
asked 05 Dec '13, 01:21
Yes, surely, as long as your documents are shorter than 2 GB.
For example, you can use a parameter with the XML data type (or a LONG VARCHAR) in stored procedures and functions, and you can use the builtin OPENXML function to parse XML documents via XPath expressions.