为什么代码调试显示游标无效
create or replace procedure ss(
bn in book_lab.bookname%type)
as
ccc book_lab%rowtype;
cursor c_l is
(select * from book_lab where bookname like '%'||'bn'||'%');
begin
loop
fetch c_l into ccc;
exit when c_l%notfound ;
dbms_output.put_line (ccc.bookname);
end loop;
end ss;
调试语句
begin
ss('bn');
end;
建的表是book_lab
有的属性有
bookid bookname writerid