I'm writing a stored procedure that currently returns xml into an ado stream along with some output parms. I need to add another for explict xml statemnt to my sproc and have it returned at the same time. Any suggestions on how to do this?
I've got three ideas.
1) I'd like to be able to return a second stream, just like you can do with multiple recordsets. However, I don't know if this is even possible.
2) I could return each xml statement as a recordset...I was hoping to not have to use recordsets though.
3) Return the second xml as an output parm? I'm not sure what variable type to use or how big to make it.
Please help
Thanks
I've got three ideas.
1) I'd like to be able to return a second stream, just like you can do with multiple recordsets. However, I don't know if this is even possible.
2) I could return each xml statement as a recordset...I was hoping to not have to use recordsets though.
3) Return the second xml as an output parm? I'm not sure what variable type to use or how big to make it.
Please help
Thanks
