Life, the Internet, and Everything!

What Is Wrong With This Timestamp Trigger? Oracle on unix …

Comment on Tips for Using Time Stamps in ILE RPG by Kujo57us.

What Is Wrong With This Timestamp Trigger? Oracle on unix via telnet

CREATE OR REPLACE TRIGGER Emp_Timestamp_bc
BEFORE Insert OR Update ON emp
REFERENCING New AS New_Row
FOR EACH ROW
BEGIN
:New_Row.Last_Update_User := USER;
:New_Row.Last_Update_Date := SYSDATE;
END Emp_Timestamp;
/
When I add a row to the emp table:
insert into emp values
(10, ‘Adam’, 50000, ‘MIS’);
I get this error:
ERROR at line 1:
ORA-00947: not enough values
Please Help!

 
Next Post
092217_0320_WhatWillThe1.jpg
Miscellany

What Will The Next Generation Of Aspiring Entrepreneurs Look Like?