Trigger on table qp_list_lines not fetching data
Hi All,
Please share some ideas,
Why trigger on table qp_list_lines is not fetching data?
CREATE OR REPLACE TRIGGER xx_price_line_tgr
AFTER INSERT
ON qp_list_lines
FOR EACH ROW
DECLARE
l_return_err VARCHAR2 (240);
v_priceline_id NUMBER;
BEGIN
BEGIN
SELECT list_line_id
INTO v_priceline_id
FROM qp_list_lines_v
WHERE 1 = 1 AND list_line_id = :NEW.list_line_id;
INSERT INTO sample_table
(attribute1, attribute2
)
VALUES ('Price Line ID', v_priceline_id
);
EXCEPTION
WHEN OTHERS
THEN
l_return_err := 'others:' || 'S' || ':' || SUBSTRB (SQLERRM, 1, 55);
INSERT INTO sample_table
(attribute1, attribute2, attribute3,