create or replace procedure show_book3(reader_name varchar2)is
cursor book_cursor is
select b.reader_id,b.name,to_char(c.borrow_date,'yyyy-mm-dd') as borrow_date,
a.book_name,a.output,a.price,to_char(borrow_date+30,'yyyy-mm-dd') as return_date
from book a,reader b,borrow c
where c.reader_id=b.reader_id and
c.book_id=a.book_id and
b.reader_id in (select reader_id from reader where name=reader_name);
begin
for i in book_cursor loop
dbms_output.put_line(i.reader_id ||i.name ||i.borrow_date ||i.book_name ||i.ouput ||i.return_date);
end loop;
end show_book3;
找了半天没能发现错在哪里
提示是
警告:创建的过程带有编译错误。