INSERTPRODUCT | |
|
<DEFAULT SERVER> > <DEFAULT DATABASE> > <DEFAULT SCHEMA> > INSERTPRODUCT |
Simple Trigger of AFTER "insert ON Product"
Name | Types | Value | ||||||
---|---|---|---|---|---|---|---|---|
MSG | Variable | |||||||
Impact Analysis: |
| |||||||
N | Variable | |||||||
TITLE | Variable | |||||||
Impact Analysis: |
|
Name | Definition | |
---|---|---|
No Data |
CREATE OR REPLACE TRIGGER InsertProduct
AFTER insert ON Product
FOR EACH ROW
DECLARE
n INTEGER;
title nvarchar2(50);
msg nvarchar2(50);
BEGIN
title := concat('Insert Product id: ',:new.Id);
msg := concat('Insert a product');
INSERT INTO AppLog (Log_date, Action, Title,Message) VALUES (SYSDATE,AppLogPk.GetActionId('INS PRODUCT'), title,msg);
END
Name | Types | Description |
---|---|---|
<DEFAULT SCHEMA>.APPLOGPK | Package | Package, Interface |
<DEFAULT SCHEMA>.APPLOG | Table | Table |
<DEFAULT SCHEMA>.PRODUCT | Table | Table |
CONCAT | Function | PL/SQL System Function |
<DEFAULT SCHEMA>.APPLOGPK.GetActionId | Function | Function interface GetActionId(actionName NVARCHAR2) return INTEGER, Package APPLOGPK |
SYSDATE | Function | PL/SQL System Function |
<DEFAULT SCHEMA>.APPLOG.ACTION | Column | Column |
<DEFAULT SCHEMA>.APPLOG.LOG_DATE | Column | Column |
<DEFAULT SCHEMA>.APPLOG.MESSAGE | Column | Column |
<DEFAULT SCHEMA>.APPLOG.TITLE | Column | Column |
INTEGER | PL/SQL System type | PL/SQL System Object |
NVARCHAR2 | PL/SQL System type | PL/SQL System Object |
<DEFAULT SCHEMA>.PRODUCT.ID | Primary Key | Column |
Name | Types | Description |
---|---|---|
<DEFAULT SCHEMA>.PRODUCTS.CreateProduct.Insert | Insert Statement | INSERT INTO PRODUCT (name, description,prod_size,quantity,unit_price) VALUES (name, description,prod |