INSERTPRODUCT


<DEFAULT SERVER>   >   <DEFAULT DATABASE>   >   <DEFAULT SCHEMA>   >   INSERTPRODUCT   

Simple Trigger of AFTER "insert ON Product"
Name Types Value
MSG Variable
Impact Analysis:
Object calling \"MSG\" Object Type
<DEFAULT SCHEMA>.INSERTPRODUCT Trigger
<DEFAULT SCHEMA>.INSERTPRODUCT.Insert Insert Statement
N Variable
TITLE Variable
Impact Analysis:
Object calling \"TITLE\" Object Type
<DEFAULT SCHEMA>.INSERTPRODUCT Trigger
<DEFAULT SCHEMA>.INSERTPRODUCT.Insert Insert Statement
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