Creating a background process
604936Oct 24 2007 — edited Oct 24 2007Hi,
I am trying to write a user stored procedure which will be fired at database startup,check for messages in a queue(sort of a listener for the queue),and perform certain operations thereafter.
I have the proc ready.but I want to make it a background process as it is supposed to run in an infinite loop.
Can anybody throw any light on how to achieve this.