CREATE OR REPLACE PROCEDURE BranchAppProc
(BranchIN IN Branch.Branchname.Branchname%TYPE,
BranchPOPUIN IN Branch.Branchname.Branchpopulation%TYPE)
IS
BranId Branch.branchID%TYPE;
BranRec Branch%ROWTYPE;
CURSOR BranCur
 IS
SELECT * FROM Services LEFT JOIN Application ON
Services.ApplicationID=Application.ApplicationID
WHERE BranchID=BranchID;
BranInfoRec

CREATE OR REPLACE TRIGGER vendorpricingTR
BEFORE UPDATE OF pricing ON vendors
FOR EACH ROW
DECLARE 
ActionVar char(6);
BEGIN

IF UPDATING THEN
ActionVar :=’UPDATE’;
END IF;
INSERT into VENDORS
(vendorsname,addr,pricing,ratings, Action)
VALUES (:old.vendorsname, :old.addr,