Hi , I have posted my query but for some reason this errors out CREATE TRIGGER z_LOGIN2 AFTER UPDATE OF lastsignondttm ON SYSADM.PSOPRDEFN FOR EACH ROW BEGIN SELECT DISTINCT a.oprid, a.oprdefndesc, a.lastsignondttm,a.lastupddttm,a.lastupdoprid, b.rolename from SYSADM.psoprdefn a, SYSADM.psrole…

how about this? (I had to add an extra value to your insert statement because ‘reasondesc’ was not in the select) CREATE OR REPLACE TRIGGER z_LOGIN2 AFTER UPDATE OF lastsignondttm ON SYSADM.PSOPRDEFN REFERENCING NEW AS New OLD AS Old FOR EACH ROW BEGIN INSERT INTO SYSADM.PS_FZAP_AUDIT_LOGS …

Create Trigger on update and insert is not working

Toad for Oracle & DevOps Toolkit

winona December 3, 2013, 12:26pm 21

[Y]Yes now it says "Trigger created " the issue was due to insufficient privileges

Topic		Replies	Views
Trigger on update and select and insert into ztable Toad for SQL Server	1	1012	January 1, 2014
Error Position: 0 Return: 4091 - ORA-04091: mutating, trigger/function Toad for Oracle & DevOps Toolkit	3	1431	December 24, 2013
Error Position: 0 Return: 1843 - ORA-01843: not a valid month ORA-06512: Toad for Oracle & DevOps Toolkit	2	3014	December 26, 2013
Toad compare - wrong trigger code Toad for Oracle & DevOps Toolkit	26	1080	November 18, 2024
Rebuild table trigger definition Toad for Oracle & DevOps Toolkit	12	2301	July 27, 2017

Create Trigger on update and insert is not working

Related topics