Stored Procedure Query Subject

[vsudaya]

Hi all,

If Stored Procedure Query Subject is not returning any resultset whether can we view it in published package(in Report Studio).  If so, how can i pass parameters to stored procedure using prompt page.

We have a stored procedure which is accepting some input parameters doing some DML operations only.

Thanks in advance
vsud

[MFGF]

Hi,

If you're using ReportNet, you can only call stored procedures which return a data set.  If you're using Cognos 8, you can also call stored procedures that perform DML, but these are not available for use from Report Studio - just Event Studio.

Regards,

MF.

[vsudaya]

Hi,

I have scenario like this. We are calling SQL Server 7 stores proc which is having insert,delete statement in between through composite studio and published to framework manager. But when i call this store proc in composite studio, its hanging without giving any result?. Whether can we use these kind of store proc in Composite studio or Framework manager.

can anybody have idea on this.

thank in advance
vsud