Using a stored procedure that return xml

Posts   
 
    
RP
User
Posts: 6
Joined: 01-Nov-2006
# Posted on: 09-Mar-2007 16:50:56   

Hello,

I have a stored procedure that returns an XML (uses SELECT with FOR XML). However the application sees it as a Action Stored Procedure call and not Retrieval Stored Procedure call, I guess because it does not return a Datatable. Please suggest, how can I use this stored procedure in the generated code.

Thanks,

Riyaz

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39927
Joined: 17-Aug-2003
# Posted on: 10-Mar-2007 11:48:34   

Return the XML via an output parameter.

Frans Bouma | Lead developer LLBLGen Pro