You could use the dbms_job package. You don't need to start it.
Jim
--
Our new email address is kennedy-family_at_home.com
Have a happy Holiday.
<pjeromel_at_my-deja.com> wrote in message news:93j51g$15s$1_at_nnrp1.deja.com...
> 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 - 21:11:30 CST
