SQL & PL/SQL

Hi to all,
Please inform my if there is another way to create job in trigger to run batch file.



SQL> create table test( name varchar2(200));

Table created.

SQL> create or replace
2 TRIGGER AFT_INSERT
3 AFTER INSERT ON Test
4 FOR EACH ROW
5 DECLARE
6 a varchar2(200);
7 BEGIN
8
9 create_job_through_trigger;
10
11 END ;
12 /

Trigger created.

SQL> insert into test values('ff');
insert into test values('ff')
*
ERROR at line 1:
ORA-04092: cannot in a trigger
ORA-06512: at "SYS.DBMS_ISCHED", line 124
ORA-06512: at "SYS.DBMS_SCHEDULER", line 271
ORA-06512: at "FINAL.VSM_SCHEDULER", line 5
ORA-06512: at "FINAL.AFT_INSERT", line 5
ORA-04088: error during execution of trigger 'FINAL.AFT_INSERT'

The create_job_through_trigger

CREATE OR REPLACE PROCEDURE create_job_through_trigger
is

BEGIN
DBMS_SCHEDULER.CREATE_JOB (
job_name => 'ajob',
job_type => 'EXECUTABLE',
job_action => 'c:\a.bat',
enabled => false);
END;
/