Hi all,
I was created a after insert trigger,But when i try insert the data into table it getting a problem. can any help to fix this issue.
CREATE OR REPLACE TRIGGER QUOTE_TOTAL_PRICE_TRG
AFTER INSERT
ON HEADERS
FOR EACH ROW
DECLARE
QUOTE_TOTAL_PRICE VARCHAR2(20);
BEGIN
SELECT NET_PRICE INTO QUOTE_TOTAL_PRICE
FROM(SELECT SUM(NVL(NET_PRICE,0))AS NET_PRICE,
HEADER_ID
FROM PA_LINES
GROUP BY HEADER_ID);
INSERT INTO HEADERS
(TOTAL_PRICE)
VALUES
(QUOTE_TOTAL_PRICE);
END;
/
When i try to insert the data into table i am getting the below error.
java.sql.SQLException: ORA-04098: trigger 'XXMULE.QUOTE_TOTAL_PRICE' is invalid and failed re-validation
But in workspace that trigger was valid.