We have a requirement to access Stored procedures residing on SQL Sever 2008 from webMethods. However, the SPs have return types of XML RAW and XML AUTO which cannot be recognised by the JDBC adapter. Is there a way to extract the output of these SPs into varchar?
FYI the SP we are trying to access is as follows:
ALTER procedure [dbo].[Int_GetDate]
declare @DateNow as datetime
set @DateNow = getDate()
select @DateNow as Int_Initiate_Message FOR XML RAW–, XMLDATA
Any thoughts would be appreciated.