To be populated by a sequence, and create new sequence named DD_PTRACK_SEQ for theĬreate a single trigger for recording the requested information to track pledge Taken (INSERT, UPDATE, or DELETE), and the idpay value for the payment record.Ĭreate a table named DD_PAYTRACK to hold this information. Information should be captured in a separate table: username, current date, action Each time a pledge payment is added, changed, or removed, the following The organization wants to track all pledge paymentĪctivity. I think something is going on with this example and my lack of the NULL value entry there in the IF statement, but unsure where to put that part in my coding.Īnd of course the Oracle 11g Reference Doc for Triggers, I've gone over it but you can check it out yourself too.ġ.
I'm not sure if my declarations are correct and the first two statements after the BEGIN statement are correct as that 1st line was flagged as a compilation error. It is having problems with my Bind Variables :NEW from the sequence, and also the idpay value inserted from another Table.
#Ninox database trigger after update how to
I need some help figuring out how to get my trigger to compile. I have read that using SERIAL not null on the Table column entry may eliminates the need for a sequence and referencing table, but I need that for my homework to work. I am running into compilation issues with my trigger and am having trouble understanding how to create a trigger that references a sequence and another table, and insert those values into a log table that I've created.
0 kommentar(er)
