Wanted some info for top1 query -using cursors

[sudhakar]

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
sudha...@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

[James Valenti]

Try removing the order by in the in line view.