如何在PL/SQL存储过程中调用已创建的触发器？

首先明确：触发器不能直接被存储过程调用，它只能通过绑定的DML事件（UPDATE/INSERT/DELETE）自动触发。你的emp_trigger绑定的是Required_table的BEFORE UPDATE事件，但当前存储过程里只有INSERT操作，所以触发器不会执行。以下是几种可行的处理方案：

方案一：修改触发器触发事件，包含INSERT #

如果你的需求是在插入或更新Required_table时都执行日志表的清理和插入逻辑，直接修改触发器的触发条件即可，存储过程无需改动：

create or replace Trigger emp_trigger
Before update or insert on Required_table 

Begin
    delete from log_table;  
    insert into log_table(employee_name,phone_number,company_name,location,currency)
    select employee_name,phone_number,company_name,location,currency 
    from Required_table;
end;
/

方案二：在存储过程中执行UPDATE操作触发触发器 #

如果不想修改触发器，可在存储过程的INSERT逻辑完成后，对Required_table执行一次不影响数据的UPDATE操作，触发绑定的触发器：

create or replace procedure excercise_one 
is 
    cursor test_cur is 
        select employee_details.emp_name,employee_details.emp_mobile_no,company.company_name,
               location.area,currency.currency
        from employee_details, company, location, currency
        where employee_details.id = company.emp_no 
          and company.location = location.country 
          and location.location_id = currency.location;

    ename employee_details.emp_name%type;
    emp_mob Employee_Details.Emp_Mobile_No%type;
    cname company.company_name%type;
    l_area location.area%type;
    cur currency.currency%type;
begin
    open test_cur;
    loop
        fetch test_cur into ename,emp_mob,cname,l_area,cur;
        exit when test_cur%notfound; -- 优化循环写法，更简洁
        insert into Required_table values (ename,emp_mob,cname,l_area,cur);
    end loop;
    close test_cur;

    -- 执行无意义的UPDATE触发触发器，需确保表中有可更新的字段
    update Required_table set employee_name = employee_name;
end;
/

⚠️ 注意：如果Required_table数据量较大，全表UPDATE会影响性能，此方案仅适合小数据量场景。

方案三：封装日志逻辑为独立存储过程（推荐） #

将触发器中的日志清理/插入逻辑抽成通用存储过程，触发器和业务存储过程都调用它，实现逻辑复用，后期维护更方便：

1. 创建通用日志存储过程 #

create or replace procedure refresh_log_table
is
begin
    delete from log_table;  
    insert into log_table(employee_name,phone_number,company_name,location,currency)
    select employee_name,phone_number,company_name,location,currency 
    from Required_table;
end;
/

2. 修改触发器调用该存储过程 #

create or replace Trigger emp_trigger
Before update on Required_table 
Begin
    refresh_log_table;
end;
/

3. 修改业务存储过程调用日志存储过程 #

create or replace procedure excercise_one 
is 
    cursor test_cur is 
        select employee_details.emp_name,employee_details.emp_mobile_no,company.company_name,
               location.area,currency.currency
        from employee_details, company, location, currency
        where employee_details.id = company.emp_no 
          and company.location = location.country 
          and location.location_id = currency.location;

    ename employee_details.emp_name%type;
    emp_mob Employee_Details.Emp_Mobile_No%type;
    cname company.company_name%type;
    l_area location.area%type;
    cur currency.currency%type;
begin
    open test_cur;
    loop
        fetch test_cur into ename,emp_mob,cname,l_area,cur;
        exit when test_cur%notfound;
        insert into Required_table values (ename,emp_mob,cname,l_area,cur);
    end loop;
    close test_cur;

    -- 直接调用封装好的日志逻辑存储过程
    refresh_log_table;
end;
/

内容的提问来源于stack exchange，提问作者Karthiga