Originally posted by sudip If by program you mean executing a pl/sql stored procedure, You can surely do that with exeception that there should not be any commit in the procedure.
Just an update
You can have COMMIT statements within a stored procedure called from a trigger in 8i and above. The follownig code snippet is perfectly valid:
create or replace trigger emptest
before insert on emp
for each row
-- this pragma allows us to have commits!
-- testinsert is the SP containing the COMMIT
create or replace procedure Testinsert(empno in number, ename in varchar2) is
INSERT INTO TT1 (EMPNO, ENAME) VALUES (empno, ename);