Does anyone know why Cognos sets the implicit_transactions setting to ON when making a stored procedure call to the database? Better yet, is there a way to disable this so that the stored procedure runs in autocommit mode? Right now, I have to set IMPLICIT_TRANSACTIONS OFF in every stored procedure called from Cognos.
Thanks in advance!