ADO doesn't get record set back

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)

ADO doesn't get record set back

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-03-17 : 08:20:55

vuvi writes "I have a problem with a stored procedure that recieves a xml and insert it's data into a table.
This stored procedure returns a record set.
For some reason the stored procedure works fine thourough the query analyzer but whe it's called from the application it WORKS but the record set is not returned to the application server.

This is the code of the sp:

ALTER PROCEDURE SP_PKT_AddPermittedCIDFromXML
@list Varchar (4000)
AS

Declare @ERR_ID INT
Declare @ERR_Description VARCHAR(300)
declare @iXml int

DECLARE @Parameters table
(PTPC_PTO_ID int , PTPC_CID int , PTPC_UserId int)

exec sp_xml_preparedocument @iXml OUTPUT, @list

insert into @Parameters (A, B ,C)
select * from openxml(@ixml, '/XML/START' , 1)
with (A int , B int , C int)

SELECT A ,B , C
FROM @Parameters

GO

THE XML looks like that :
<XML>
<START A="18589" B="2" C="1"/> </XML>

IF I change the location of the select command to before the openxml then the application gets the record set.

Can any of you help me?

Thank you :)"

Stoad
Freaky Yak Linguist

1983 Posts

Posted - 2005-03-17 : 08:59:50

An ancient trouble!

ALTER PROCEDURE SP_PKT_AddPermittedCIDFromXML
@list Varchar (4000)
AS
set nocount on
... ...

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources