How to create a trigger to run a procedure at a certain time?

Question

I need to know if there is any way to create trigger to execute procedure on certain time like :

create trigger Fire 
when sysdate = 1-oct-2015 
execute (procedure);

I hope you understand me and please provide any solution how I can do it

Answer 1

Trigger is executed BEFORE or AFTER some event e.g. INSERT. To control execution at a specific time maybe you need a SCHEDULER

Simple example is here other search with "DBMS_SCHEDULER"