oracle - DBMS_OUTPUT.PUT_LINE 返回错误

Question

我正在尝试编写一个基本的 PL/SQL For 循环，但一直出现错误。我的声明是:

begin

  for tab_x in
    (select unique table_name from all_tables
     where owner like 'MSGCENTER_DBO%'
       and table_name like 'MSG_DETAIL%')
  loop
    DBMS_OUTPUT.PUT_LINE(tab_x);
  end loop;

end;
/

错误信息是

PLS-00306: wrong number or types of arguments in call to 'PUT_LINE'
ORA-06550: line 6, column 7:
PL/SQL: Statement ignored

我可能遗漏了一些非常明显的东西，但无法让它发挥作用。感谢您的帮助!

Answer 1

您想改为访问 tab_x.table_name。

begin

   for tab_x in
    (select unique table_name from all_tables
     where owner like 'MSGCENTER_DBO%'
       and table_name like 'MSG_DETAIL%')
   loop
      DBMS_OUTPUT.PUT_LINE(tab_x.table_name );
  end loop;

end;
/