Re: Question about: DBMS_AQ.DEQUEUE
From: rjamya <rjamya_at_gmail.com>
Date: Tue, 21 Feb 2012 07:38:06 -0500
Message-ID: <CAGurbTOt-dYRb=iKKrpg=C8hzapo2sr2r3aBQnN+OfKta=nqWQ_at_mail.gmail.com>
some more info please, before you started the loop, how many messages were enqueued and ready to be dequeued? Did you commit after dequeue? perhaps you can share the code and how did you determine there were less than 5000 rows and what do you mean by "Right now, I tried a PL/SQL code (from SQL Developer) that has the
loop and calls our dequeue procedure 5000 times.. it worked right now.." ... what do you mean by it worked?
Date: Tue, 21 Feb 2012 07:38:06 -0500
Message-ID: <CAGurbTOt-dYRb=iKKrpg=C8hzapo2sr2r3aBQnN+OfKta=nqWQ_at_mail.gmail.com>
some more info please, before you started the loop, how many messages were enqueued and ready to be dequeued? Did you commit after dequeue? perhaps you can share the code and how did you determine there were less than 5000 rows and what do you mean by "Right now, I tried a PL/SQL code (from SQL Developer) that has the
loop and calls our dequeue procedure 5000 times.. it worked right now.." ... what do you mean by it worked?
Raj
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Feb 21 2012 - 06:38:06 CST