Home » Developer & Programmer » Forms » DateBase Trigger from a manual insert statement in Oracle form
DateBase Trigger from a manual insert statement in Oracle form [message #420234] Thu, 27 August 2009 11:19 Go to next message
Prerna
Messages: 1
Registered: June 2009
Junior Member
Hi Experts,

I have a scenario where i have to insert/update/delete data in two tables from a data block. Table 1 and Table 2.
Data Block is created from Table 1.
Hence i update Table 2 in pre-update Trigger.
Now there is an after each row trigger on Table 2 which updates Table 3 on insert/update/delete on Table 2.
But this after each row trigger is not being called.

Does the Database trigger not get called when we manually insert/update/delete in Oracle form?

Thanks in Advance,
Prerna
Re: DateBase Trigger from a manual insert statement in Oracle form [message #420305 is a reply to message #420234] Fri, 28 August 2009 04:33 Go to previous messageGo to next message
cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester
Senior Member
Triggers always get called when their triggering action is performed unless they are disabled.

What makes you think it's not running?
Re: DateBase Trigger from a manual insert statement in Oracle form [message #420532 is a reply to message #420234] Mon, 31 August 2009 02:44 Go to previous message
c.schoeberl
Messages: 22
Registered: August 2009
Junior Member
Please let me see how you create your trigger. Just put in the Triggers code.

An other question. Did you commit after edit?

[Updated on: Mon, 31 August 2009 02:55]

Report message to a moderator

Previous Topic: client not connecting
Next Topic: Open Forms 10g in browser full screen mode(F11)
Goto Forum:
  


Current Time: Fri Sep 20 06:34:51 CDT 2024