Re: Wanted to know some info about top 1 query in cursors

Thanks martin,
It was mistake from my side. Union all query cursor was working fine. In the query below I wrongly mentioned as group by instead of order by Group by is working fine. I want order by clause.
Martin if u know then please mail me.

I want to know what are the limitations of cursors in terms of sql
I am getting error when for the following procedures...... 1.
create or replace procedure test is
Cursor Cur_SecRes is
select secresdesc,secrescode from
(SELECT SECRESDESC,secrescode FROM SECONDARYRES order BY secrescode asc, SECRESDESC desc)
WHERE ROWNUM=1;
Begin
for x in Cur_SecRes
loop
dbms_output.put_line(x.secrescode | | ' ,' | | x.secresdesc);
end loop;
End;
The above procedure is opens the top q query, which is required for imporving performance. The query is running in Sql Plus, but if I include the query in PL sql block it is giving error.
Is there any way out for running the above query, If any body knows then please let me know at
sudhakar_kb_at_hotmail.com

overall I need to know the limitations of cursor or pl sql block,

Thanks once again,

Regards,
sudhakar

• Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful