Hello,

I am trying to create trigger @insert into a table so i wrote

CREATE OR REPLACE TRIGGER V_INSERT_TRIGGER
AFTER INSERT ON VIJAY FOR EACH ROW
DECLARE
I NUMBER := :NEW.ID_V;
BEGIN
INSERT INTO TBL_TEMP_ERR VALUES (I, 'STARTING INSERTING ');
INSERT INTO MASTERTAB SELECT * FROM VIEWVIJAY WHERE ID_V = I;
EXCEPTION
WHEN NO_DATA_FOUND THEN INSERT INTO TBL_TEMP_ERR VALUES (I, 'ERROR WHILE
INSERT NO DATA FOUND');
WHEN INVALID_NUMBER THEN INSERT INTO TBL_TEMP_ERR VALUES (I, 'ERROR WHILE
INSERT INVALID NUMBER');
WHEN TOO_MANY_ROWS THEN INSERT INTO TBL_TEMP_ERR VALUES (I,'ERROR WHILE
INSERT TOO MANY ROWS IN SELECT');
WHEN VALUE_ERROR THEN INSERT INTO TBL_TEMP_ERR VALUES (I,'ERROR WHILE
INSERT VALUE ERROR');
WHEN NOT_LOGGED_ON THEN INSERT INTO TBL_TEMP_ERR VALUES (I,'ERROR WHILE
INSERT NOT LOGGED ON');
WHEN PROGRAM_ERROR THEN INSERT INTO TBL_TEMP_ERR VALUES (I,'ERROR WHILE
INSERT PROGRAM ERROR');
WHEN STORAGE_ERROR THEN INSERT INTO TBL_TEMP_ERR VALUES (I,'ERROR WHILE
INSERT STORAGE ERROR');
WHEN TIMEOUT_ON_RESOURCE THEN INSERT INTO TBL_TEMP_ERR VALUES (I,'ERROR
WHILE INSERT TIMEOUT ON RESOURCE');
WHEN ZERO_DIVIDE THEN DBMS_OUTPUT.PUT_LINE('PRBLM');
WHEN OTHERS THEN INSERT INTO TBL_TEMP_ERR VALUES (I, 'ERROR WHILE INSERT
OTHERS');
END V_INSERT_TRIGGER;


But when this is executed on insert of any record in table VIJAY it is
giving an entry in tbl_temp_err with record

the new id , ERROR WHILE INSERT OTHERS

and what is the error i do not know .. how do i solve this error

Vijay Shah
Software Developer



--------------------------
This message contains confidential information and is intended only for the
individual named. If you are not the named addressee you should not
disseminate, distribute or copy this email. Please notify the sender
immediately by email if you have received this email by mistake and delete
this email from your system.
Oracle LazyDBA home page