Hello all,
I am new in PL/SQL. I want to make a trigger which will insert Multiple row from another table.
How can I do this ?
My two tables are
CREATE TABLE EMP_PS_INFO
(
EMP_ID CHAR(6) PRIMARY KEY,
F_NAME VARCHAR2(50 ),
L_NAME VARCHAR2(50 ),
FNAME VARCHAR2(50 ),
MNAME VARCHAR2(50 ));
------------------------------------------------------------------------------
Insert into EMP_PS_INFO (EMP_ID,F_NAME,L_NAME,FNAME,MNAME) values ('000001','ABUL','HASEEB KHAN','Late Abdur Rahman Khan','Late Hasina Khatun');
Insert into EMP_PS_INFO (EMP_ID,F_NAME,L_NAME,FNAME,MNAME) values ('000002','RABEYA','BEGUM','Late Md. Sekel','LateSona Banu');
Insert into EMP_PS_INFO (EMP_ID,F_NAME,L_NAME,FNAME,MNAME) values ('000004','RAMESH','CHANFRA DAS',null,null);
Insert into EMP_PS_INFO (EMP_ID,F_NAME,L_NAME,FNAME,MNAME) values ('000005','RIZIA ','BEGUM','Late Abdul Karim Hawlader','Late Moymon Bibi');
Insert into EMP_PS_INFO (EMP_ID,F_NAME,L_NAME,FNAME,MNAME) values ('000007','MASUDA','AKTER','Late. Helal Uddin Ahmed','Late Salina Begum');
Insert into EMP_PS_INFO (EMP_ID,F_NAME,L_NAME,FNAME,MNAME) values ('000014','TUHIN','SEN','Late -mr.bidhan Krisna Sen','Anima Sen');
Insert into EMP_PS_INFO (EMP_ID,F_NAME,L_NAME,FNAME,MNAME) values ('000021','MD. ABDUR','RASHID','Late Qudrat Ali','Late Anowara Khatun');
---------------------------------------
CREATE TABLE SALARY_EMP
(
EMP_ID VARCHAR2(6),
MNYR VARCHAR2(10),
BONUS CHAR(1),
NET_SAL NUMBER(10,2),
CONSTRAINT SAL_EMP_PK PRIMARY KEY (EMP_ID,MNYR));
I have tried with this . But it comes with error ora-06512
DECLARE
CURSOR C_EMP_SAL IS
SELECT EMP_ID
FROM EMP_PS_INFO;
V_EMP VARCHAR2(6);
V_MNYR VARCHAR2(10) := '10/12';
BEGIN
OPEN C_EMP_SAL;
LOOP
FETCH C_EMP_SAL INTO V_EMP;
INSERT INTO SALARY_EMP (EMP_ID, MNYR)
VALUES (V_EMP, V_MNYR);
END LOOP;
CLOSE C_EMP_SAL;
END;
How can i solve it.
Thanks in advance