CREATE TABLE BANK 
   (	TRAN_ID NUMBER(10,0), 
	TRAN_TYPE VARCHAR2(5 BYTE), 
	AMMOUNT NUMBER(6,2), 
	LOAD_DATE TIMESTAMP (6)
   );

create  view v_bank as select * from bank;

create or replace 
TRIGGER IOI_bank
  INSTEAD OF INSERT
  ON v_bank
  
  for each row
  
DECLARE NUMROWS INTEGER;
V_LOB ACCOUNT_PROGRAMS.LINE_OF_BUSINESS%TYPE;
BEGIN

 DBMS_OUTPUT.PUT_LINE('v_lob  '||v_lob); 
  Insert into BANK
    (TRAN_ID,
      TRAN_TYPE,
      AMMOUNT,
      LOAD_DATE
    )
   values
    (:new.TRAN_ID
    ,:new.TRAN_TYPE
    ,:NEW.AMMOUNT
    ,:NEW.LOAD_DATE);
END;

SET SERVEROUTPUT ON
DECLARE
V_NUM NUMBER;
BEGIN
INSERT INTO V_BANK
VALUES (1,'BA',100,SYSDATE) RETURNING TRAN_ID INTO  V_NUM;
DBMS_OUTPUT.PUT_LINE('333333 '||V_NUM); 
END;
/