Re: Message logging in stored procedures

2002-06-15 Thread Stephane Faroult
Robert Monical wrote: > > Hello, > > Finally moving from Oracle 7 to 8 or 9 (probably 9). > > We currently use DBMS_PIPE and a scheduled job to empty the pipe and store > the messages. > Works fine in our application but I need to eventually make some improvements. > > Are there any new featu

Re: Message logging in stored procedures

2002-06-14 Thread Jared Still
You may want to investigage Advanced Queuing. It is an async messaging service in the database. There are examples at otn.oracle.com Jared On Friday 14 June 2002 18:58, Robert Monical wrote: > Hello, > > Finally moving from Oracle 7 to 8 or 9 (probably 9). > > We currently use DBMS_PIPE and a

Message logging in stored procedures

2002-06-14 Thread Robert Monical
Hello, Finally moving from Oracle 7 to 8 or 9 (probably 9). We currently use DBMS_PIPE and a scheduled job to empty the pipe and store the messages. Works fine in our application but I need to eventually make some improvements. Are there any new features in the newer Oracles to support this r