Stored Procedure in MS SQL server returning cursors

ag_ram · Post by **ag_ram** » Mon Dec 10, 2007 4:52 pm

Hi

I have a stored procedure which returns 2 cursors. My stored procedure has been written in MS SQL dabase. Can datastage handle this stored procedure... I mean whether datastage supports multiple cursors as output paramter of a stored procedure ?

Please reverk back.

Thanks
kamal

chulett · Post by **chulett** » Mon Dec 10, 2007 6:10 pm

Don't know for certain, but I don't think it will support that. From what I recall, what the Stored Procedure stage does support is listing in the pdf documentation for it, have you checked that?

lstsaur · Post by **lstsaur** » Mon Dec 10, 2007 6:50 pm

SP stage for SQL Sever has a CursorOutput parameter available for a record or a result set returned from the stored procedure, but it sure cannot handle the multiple cursors.