CREATE OR REPLACE TRIGGER trigger1
	AFTER INSERT ON table1
	FOR EACH ROW
  DECLARE 
	NOW(), -- TIME_STAMP
    NEW.ID, -- BC_ID
    NEW.BC_STATUS, -- BC_STATE
    NEW.BUSINESS_PROCES_FK, -- BUSINESS_PROCESS_ID
    1, -- BUSINESS_CASE_PRIORITY
    NULL, -- BUSINESS_CASE_DURATION
    NEW.CLIENT_FK -- CLIENT_ID
  BEGIN
      INSERT INTO table2(
        TIME_STAMP,
        BC_ID,
        BC_STATE,
        BUSINESS_PROCESS_ID,
        BUSINESS_CASE_PRIORITY,
        BUSINESS_CASE_DURATION,
        CLIENT_ID
      )
   END;

CREATE OR REPLACE TRIGGER trigger1
  AFTER INSERT ON table1
  FOR EACH ROW
BEGIN
  INSERT INTO table2 
    -- column names in table2 to insert into:
    (TIME_STAMP,
     BC_ID,
     BC_STATE,
     BUSINESS_PROCESS_ID,
     BUSINESS_CASE_PRIORITY,
     BUSINESS_CASE_DURATION,
     CLIENT_ID)
  VALUES 
    -- values, including :new values from table 1
    -- to insert into table2:
    (SYSTIMESTAMP,
     :NEW.ID,
     :NEW.BC_STATUS,
     :NEW.BUSINESS_PROCESS_FK,
     1,
     NULL,
     :NEW.CLIENT_FK);
END trigger1;
/
SHOW ERRORS