Hey there everyone, I'm new here, so I hope I haven't done any mistakes so far So, I want to create a procedure which adds a comment on each column of a table. The text of the comment sould be the columns name itself. It seems like I can't use "comment on" natively in a procedure, so I guess I have to use the "execute immediate" statement to do so. This is how I tried to do this, but without any success: Code (Text): procedure column_names_as_comment (p_table_name user_tab_columns.table_name%type) is -- cursor with table and column name cursor c_table_to_comment is select table_name,column_name from user_tab_columns where table_name = p_table_name; -- rowset for the cursor r_table_to_comment c_table_to_comment%rowtype; begin for r_table_to_comment in c_table_to_comment loop execute immediate 'comment on column '|| r_table_to_comment.table_name ||'.'|| r_table_to_comment.column_name ||''' is '''|| r_table_to_comment.column_name ||''' '; end loop; end; I hope you can give me a hint, or another idea how to reach my goal. Thanks in advance!