In this blog post, you’ll learn more about the Sybase Error Insufficient memory for OPENXML query and the reason for receiving this error
Sybase SQL Error Message
Insufficient memory for OPENXML query
Reason for this Error
The memory used by an OPENXML query may be proportional to the maximum distance between elements or attributes returned by a single row. For example, a query where some row uses the value from both the first and last element in the document may use memory proportional to the size of the document. One solution is to increase the cache size. Another is to break a query that refers to distant elements into several queries that refer to nearby elements and join the results.
