User Profile
Collapse
-
Action is a new column I want to insert in the table.......... .....Leave a comment:
-
viny2cool started a topic I am creating this stored procedure. but I am not able to solve these errors.in OracleI am creating this stored procedure. but I am not able to solve these errors.
Here is my code :
...Code: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
-
ORA-00904: "ACTION": invalid identifier
Hey guys I am trying to create an trigger, but getting this error. My code is as follows
...Code: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,
No activity results to display
Show More
Leave a comment: