|
Hi
Please help me create a trigger. This is the code but i am getting errors
CREATE Trigger MyTrigger
AFTER
update [or delete] on dbo.Products
REFERENCING OLD AS oldRow
for each row
BEGIN
UPDATE ncache_db_sync
SET modified = 1
WHERE cache_key = (Cast(Select oldRow.ProductID FROM deleted OLD) As VarChar) + ':dbo.Products'
END TRIGGER;
Errors:
4 26 PL/SQL: ORA-00936: missing expression
2 2 PL/SQL: SQL Statement ignored
5 12 PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following: begin case declare end exception exit for goto if loop mod null pragma raise return select update while with
I could not figure out the problem, please help
Thanks
| 
