Start Processes automatically on DB startup??

Does anyone know how I can start a process (or multiple processes) automatically
on startup of a DB?

The main catch is that the process does a INFINITE LOOP waiting for messages
from a DBMS_PIPE (currently wanting to use this as a DEBUGGING tool,
although this will be used for another reason later). Hence the process will lock any session that it is created in.

I thought about using the JOB package, and the ADVANCED QUEUING
package, but would prefer to rely on an automatic process rather than a manually
started one.

I can't run a SQL session after starting the database because the process I want
would lock the SQL session.

Anyone have any ideas, or better suggestions.

Thanks.
Paul

Sent via Deja.com
http://www.deja.com/ Received on Wed Jan 10 2001 - 20:16:22 CST