Problem with XML reading into Variable

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Problem with XML reading into Variable

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-02-13 : 07:38:27

kalpesh writes "Hi there,
I am using SQL2k to read XML and use the XML value for other reference.here is my sample code

SELECT @hr1 = -1
EXEC @hr1 = master..sp_OACreate 'Microsoft.XMLHTTP' ,@objSJ1 OUTPUT
IF @hr1 = 0
BEGIN
SELECT @hr1 = -1
End
EXEC @hr1 = master..sp_OAMethod @objSJ1 ,'OPEN' , null,'Get',@PassAdd1,false
IF @hr1 <> 0
BEGIN
EXEC sp_OAGetErrorInfo @objSJ1
RETURN
END
EXEC @hr1 = master..sp_OAMethod @objSJ1,'send', null
IF @hr1 <> 0
BEGIN
EXEC sp_OAGetErrorInfo @objSJ1
RETURN
END

-- here is Problem I have.

here @sXML1 is output hander and having maximum variable length
as varchar(8000). My return XML is having
more 8000 char.

EXEC @hr1 = master..sp_OAMethod @objSJ1,'responsetext', @sXML1 OUTPUT

Can any one please suggest me how to read large XML file using
OPENXML.

IF @hr1 <> 0
BEGIN
EXEC sp_OAGetErrorInfo @objSJ1
RETURN
END

exec sp_xml_preparedocument @Idoc1 output,@sXML1

select @Stname1=cast(text as varchar(100)) from OPenXMl (@idoc1, '/',1) where nodetype=3

Thanks for help.

Kalpesh"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources