Sql代码在cmd中运行出现警告编译错误，想问问哪里编的不对了

create or replace procedure proc_8

as

begin

  for traveller_rec in(

  select r.travellerid, t.givenname, t.familyname, ta.housenumber, ta.nameofstreet, ta.typeofstreet, ta.state, ta.location, ta.postalcode, c.tradingas

    from reservation r,traveller t,travellerAddr ta, carrier c

   where r.travellerid=t.travellerid and trim(t.travellerid)=ta.travellerid and t.loyaltyprog=c.carrierid

group by r.travellerid, t.givenname, t.familyname, ta.housenumber, ta.nameofstreet, ta.typeofstreet, ta.state, ta.location, ta.postalcode, c.tradingas, c.carrierid

having count(journeyid)>=2

order by c.carrierid,t.familyname,ta.postalcode)

loop

  dbms_output.put_line('ID:'||traveller_rec.travellerid);

  dbms_output.put_line(traveller_rec.familyname||','||traveller_rec.givenname);

  dbms_output.put_line(traveller_rec.housenumber||' '||traveller_rec.nameofstreet||' '||traveller_rec.typeofstreet||','||traveller_rec.location||'.');

  dbms_output.put_line(traveller_rec.state||'.'||traveller_rec.postalcode||chr(10)||chr(13));

end loop;

end;

/

是不是文件尾部多了/ 导致编译失败。

您好，我是有问必答小助手，您的问题已经有小伙伴解答了，您看下是否解决，可以追评进行沟通哦~

如果有您比较满意的答案 / 帮您提供解决思路的答案，可以点击【采纳】按钮，给回答的小伙伴一些鼓励哦～～

ps:问答VIP仅需29元，即可享受5次/月 有问必答服务，了解详情>>>https://vip.csdn.net/askvip?utm_source=1146287632