xml in stored procedure

[Former Member]

Hi, can I Use Xml as parameter to stored procedure and parse xml inside the procedure? . your idea is greatly appreciated..

Thanks vhm

[VolkerBarth]

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.