rliq
August 29th, 2001, 02:46 AM
In an SQL2000 Stored Procedure...
I have a column in a table called 'xml_text', it is of type TEXT and contains XML. I want to be able to pass the contents of this column (I know which row) to the sp_xml_preparedocument Stored Procedure. It says in the documentation that I can pass a TEXT data type variable which contains the XML to be parsed.
How do I pass a TEXT data type variable after reading it in from a table when I can't DECLARE local TEXT data type variables in a Stored Procedure and I don't seem to be able to do it all on the 'sp_xml_preparedocument' line as it complains about the syntax...??
The xml_text column contains >8000 chars.
I have tried all I know and cannot see how you pass TEXT as a parameter to a stored procedure, unless you hard-code the XML...
Any help is appreciated...
Rob.
I have a column in a table called 'xml_text', it is of type TEXT and contains XML. I want to be able to pass the contents of this column (I know which row) to the sp_xml_preparedocument Stored Procedure. It says in the documentation that I can pass a TEXT data type variable which contains the XML to be parsed.
How do I pass a TEXT data type variable after reading it in from a table when I can't DECLARE local TEXT data type variables in a Stored Procedure and I don't seem to be able to do it all on the 'sp_xml_preparedocument' line as it complains about the syntax...??
The xml_text column contains >8000 chars.
I have tried all I know and cannot see how you pass TEXT as a parameter to a stored procedure, unless you hard-code the XML...
Any help is appreciated...
Rob.