triggers and commit

It has been well documented in the mannuals, that one cannot use commit or rollback statments in triggers.

	There are two questions that I would like to ask:


	(1). The rational or why is it that commit and rollback


	are not allowed?.


	(2). In the project that I am working, I am using  ms-access as client


	and oracle as server. I have situations where, I need to insert
	records into tables using triggers at the server. This works fine.
	The problem occurs when I am trying to query the new records that
	have been inserted through triggers from my client. The records don't
	seem to exist. But if, I give an explicit commit after the triggers
	have been executed, my client gets a positive answer.
	
	My question is that I want to use triggers for the above mentioned
	actions and at the same time I would like my client get positive
	answers. Is there a way out?.

	thanks for the help and suggestions

-anand

--
Anand. V. J				Internet:fbap3120_at_leonis.nus.sg
Dept Of Decision Sciences
National University Of Singapore