SQL>
SQL>
SQL> create table myTable
2 (id number,
3 recipient varchar2(80),
4 gid number);
Table created.
SQL>
SQL> create or replace trigger worknotbr before insert
2 on myTable for each row
3 declare
4 jobno number;
5 begin
6 dbms_job.submit(job => jobno, what => 'email( job );');
7 :new.gid:= jobno;
8 end;
9 /
Trigger created.
SQL> create or replace procedure email (job in number) is
2 lv_recipient myTable.recipient%type;
3 begin
4 select recipient into lv_recipient from myTable where gid = job;
5 end;
6 /
Procedure created.
SQL>
SQL>
SQL>
SQL> drop table myTable;
Table dropped.