troubleshooting Question

Warning: Trigger created with compilation errors. Oracle 10g SQL plus

Avatar of gritscbs
gritscbs asked on
Oracle Database
6 Comments1 Solution13535 ViewsLast Modified:
Please help,

I am attempting to create a trigger to fire a procedure but when I create the trigger I get:
   Warning: Trigger created with compilation errors.

The procedure and trigger are below (the procedure created with no errors).
-----
create or replace procedure transdtl_to_item(id2 number) as
pragma autonomous_transaction;
begin
 INSERT INTO PROJECT_FILE_ITEMS (PROJECT_ID, PROJECT_FILE_ID, COST_CODE, DESCRIPTION, DATE_RECEIVED, COST_PER_UNIT, AUTHORIZED_BY, DATE_ORDERED, CURRENTLY_ASSIGNED_TO, NOTES, VENDOR_NAME, VENDOR_ID) SELECT PROJECT_ID, TRANS_ID, TRANS_DETAIL_ID, DESCRIPTION, TRANS_DATE, (HOURS * COST_PER_HOUR) + MEAL_COST + OTHER_COST, AUTHORIZED_BY, CREATEDATE, DRIVER, PUBLIC_NOTES, VENDOR, VENDOR_NUMBER FROM TRANS_DETAIL WHERE TRANS_DETAIL_ID = id2;
 commit;
end;
--------

CREATE OR REPLACE
TRIGGER TRANS_TO_ITEM
 AFTER UPDATE OF COMPLETE_FOR_BILLING ON TRANS_DETAIL
REFERENCING OLD AS ID3 NEW AS ID4
FOR EACH ROW
WHEN (ID4.complete_for_billing = 'Invoice Via Project')
BEGIN
  transdtl_to_item(:id2.trans_id);
END;

Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros