Tolong bantuan unt ahli ahli ocale , saya punya tabelA dan TabelB. Bagai mana
cara triger dan sp apabila tabela di insert langsung insert tabelB??
gambaran nya:
CREATE TABLE TABELA
(
NOTRXA CHAR(18 BYTE), NOT NULL,
)
CREATE TABLE TABELB
(
NOTRXB CHAR(19 BYTE) NOT NULL,
)
===========sp==========================
CREATE OR REPLACE PROCEDURE tabelA_isi(p_notrx in string) IS
pragma autonomous_transaction;
cursor empList is select * from tabelA where NOTRXA=p_notrx ;
begin
for empRec in empList loop
INSERT INTO tabelB (NOTRXB ) VALUES(empRec.NOTRXA);
commit;
end loop;
end;
/
==============triger=======================
CREATE OR REPLACE TRIGGER tabelA_isitring
after insert on tabelA
for each row
begin
tabelA_isi(:new.NOTRXA);
end;
/
==============================================
insert into tabelA (NOTRXA) values ('01/201002/000002');
Thanks yaaaaaaaaaaaaaaaaaaaaaaaaa
[Non-text portions of this message have been removed]
