Return
-
Title
When Hex A0 (non-breaking space) is embedded in stored procedure code,Toad can't open the stored procedure -
Description
The following error occurs when trying to load a stored procedure that includes a Hex A0 (non- breaking or fixed space):
System.Xml.XmlExceptionThe 'ERROR_TOKEN' start tag on line 30 position 2 does not match the end tag of 'MESSAGE'. Line 103, position 3.Stack Trace:at System.Xml.XmlTextReaderImpl.Throw(Exception e)at System.Xml.XmlTextReaderImpl.ThrowTagMismatch(NodeData startTag)at System.Xml.XmlTextReaderImpl.ParseEndElement()at System.Xml.XmlTextReaderImpl.ParseElementContent()at System.Xml.XmlLoader.LoadNode(Boolean skipOverWhitespace)at System.Xml.XmlLoader.LoadDocSequence(XmlDocument parentDoc)at System.Xml.XmlDocument.Load(XmlReader reader)at System.Xml.XmlDocument.LoadXml(String xml)at Quest.QP5.Chunk.ParseInfo(ParseInfoFlag flags)at Quest.Toad.SqlServer.Doe.Common.QP5Parser.QP5Parser.GetFirstChunkXmlDocument(String body, ParseInfoFlag parseInfoFlag)This issue also affects Schema Compare (when comparing schemas containing the object in question) and when you try to edit the code in the 'Alter' window in Object Explorer, the following message may show:
Quest.Toad.SqlServer.Doe.Common.QP5Parser.QP5ParserWrappingException
QP5 parsing error in 'GetFirstChunkXmlDocument'
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.