SQL & PL/SQL

Hi All,

I am using a After insert trigger to generate history record as following:

CREATE TABLE TB_TEST (classID number(3), classNm varchar2(12));

CREATE TABLE TB_HIST_TEST (hist_dttm timestamp(6), classID number(3), classNm varchar2(12));

CREATE or REPLACE TRIGGER air_test AFTER INSERT ON tb_test FOR EACH ROW

BEGIN PK_SRVC.CRT_NewRec('TB_TEST', 'TB_HIST_TEST', :new.ROWID); END:

In PK_SRVC package, I use the following statment to create new record in TB_HIST_TABLE:

     Insert into tb_hist_test (hist_dttm, classID, classNm)

     values (select systimestamp, classID, classNm from tb_test where rowid = ROWID )

The trigger DOES fire when a new row is inserted into TB_TEST. However there is no record inserted into TB_HIST_TEST. Any suggestion?

Thanks,