Re: Advanced Queueing

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Fri, 03 Dec 1999 15:27:05 GMT
Message-ID: <3847dff1.11140108@newshost.us.oracle.com>

On Fri, 3 Dec 1999 10:15:23 -0000, "Norman Mann" <nm_at_prismtechnologies.com> wrote:

>I have a question on Oracle 8's advanced queueing. (Oracle 8.04)
>If I start a queue and either drop the user, or restart Oracle, I cannot use
>or drop the queue.
>
>I get the error:
>
>Enter value for 1: ds_ip
>begin dbms_aqadm.stop_queue( queue_name => 'ds_ip.pmd_sync_q2'); end;
>
>*
>ERROR at line 1:
>ORA-00600: internal error code, arguments: [kwqiclod: no TOI], [1403], [],
>[], [], [], [], []
>
>
>This is easily repeatable, has anyone any ideas?
>I also seem to get strange locking problems.

Call Oracle Worldwide Support and reference bug # 1082088. This sounds like the same type of problem.

>
>Any help appreciated
>
>Norman
>
>
>

Thanks!

Joel

Joel R. Kallman Oracle Service Industries

Columbus, OH                             http://govt.us.oracle.com

jkallman@us.oracle.com                   http://www.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Fri Dec 03 1999 - 09:27:05 CST