
create or replace procedure SUNO_PROD.PROD.DIM_CLIP_HOURLY_INSERT_PROC(
    stage_path string,
    p_date date,
    p_hour string
)
returns number
language sql
execute as caller
as
$$
declare
    start_time TIMESTAMP;
    row_count number;
begin
    -- Record the start time for monitoring
    start_time := CURRENT_TIMESTAMP();
    
    -- Call the existing insert procedure
    call SUNO_PROD.PROD.DIM_CLIP_INSERT_PROC(:stage_path) into :row_count;
    
    -- Log the execution
    call TASK_MONITOR_INSERT_PROC('DIM_CLIP_HOURLY_INSERT_PROC', :start_time, :row_count, 'SUCCESS', 'HOURLY');
    
    return row_count;
end;
$$;