Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

XML Retrieval Error Using XMLEXTRACT()

12 views
Skip to first unread message

james....@wellsfargo.com

unread,
Jun 13, 2006, 4:36:50 PM6/13/06
to
Anybody seen anything like this? It seems that Sybase 12.5.x
can not deal with namespaces at the top of an XML file.


1> select xmlextract("/", content) from DU_Response_30_proxy
where filename =
'LDCDU.output.01ML100101148808182006060714490701.200606071449583151.xml'
2> go
Msg 14702, Level 16, State 0:
Server 'IRMQ14', Line 1:
XMLEXTRACT(): XML parser fatal error <<An exception
occurred!
Type:RuntimeException, Message:The buffer manager cannot
provide any more buffers>> at line 19, offset 3818.

1> select xmlextract("/", content) from DU_Response_30_proxy
where filename =
'LDCDU.output.01ML100101148808182006060716370601.200606071638407279.xml'
2> go
Msg 14702, Level 16, State 0:
Server 'IRMQ14', Line 1:
XMLEXTRACT(): XML parser fatal error <<An exception
occurred!
Type:RuntimeException, Message:The buffer manager cannot
provide any more buffers>> at line 19, offset 3818.

0 new messages