Hello all.
I am trying to execute a procedure that utilizes temp tables to be used as a data source for my report. The procedure is a multi step process which utilizes a set of #tables throughout its execution.
The impromptu report basically telling me that I can not perform a insert into from within a transaction. Well, I have been trying to find some option that is making the report run from within a transaction. (why a transaction would be wrapped around a report is beyond me but anyways)
I have seen document 99397 from Cognos knowledge base referenced, but I do not have support. (support is always an after thought).
Anyone have any ideas??
I am trying to execute a procedure that utilizes temp tables to be used as a data source for my report. The procedure is a multi step process which utilizes a set of #tables throughout its execution.
The impromptu report basically telling me that I can not perform a insert into from within a transaction. Well, I have been trying to find some option that is making the report run from within a transaction. (why a transaction would be wrapped around a report is beyond me but anyways)
I have seen document 99397 from Cognos knowledge base referenced, but I do not have support. (support is always an after thought).
Anyone have any ideas??