Re: Question about: DBMS_AQ.DEQUEUE

From: Mani <manips2002_at_gmail.com>
Date: Thu, 23 Feb 2012 23:57:07 -0500
Message-ID: <CAHN-UzmYNxgL-iftMx2FCMDTSA0961Xa+=qn1E1dhNGbR5=fxg_at_mail.gmail.com>



Hi,

I had a question about using ORDER BY in a CURSOR declaration..

The following cursor declaration appears to not work.. the compilation error is about missing right paranthesis..

  CURSOR x1 IS
(SELECT c1

     FROM T1
     ORDER BY c2);

If I rewrite it by removing the paranthesis, or if I rewrite it as below, it works..

  CURSOR x1 IS
(SELECT c1

     FROM T1)
     ORDER BY c2;

can you let me know where I can find more information about this..?? or can you explain this a little bit more..

thanks, murali.

--
http://www.freelists.org/webpage/oracle-l
Received on Thu Feb 23 2012 - 22:57:07 CST

Original text of this message