Wanted some info for top1 query -using cursors

Hi all,
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 in advance.....

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