CODEWITHSUNDEEP
sqloracle-databaseplsql
user4226899
user4226899

Reputation:

Dynamic add comment on table or view

I want to add comment on table or view with procedure using dynamic SQL.

I have tried this but unsuccessfully:

create or replace procedure add_comment(
  p_table   in varchar2,
  p_comment in varchar2
)
as

BEGIN
    EXECUTE IMMEDIATE 'comment on table "' || p_table || '" is 

    ' || p_comment || '  end;'

      ;  
END;

Upvotes: 0

Views: 289

Answers (1)

Aleksej
Aleksej

Reputation: 22949

Your dynamic SQL should be edited to avoid the end and handle the quotes:

CREATE OR REPLACE PROCEDURE add_comment(p_table IN VARCHAR2, p_comment IN VARCHAR2) AS
BEGIN
    EXECUTE IMMEDIATE 'comment on table "' || p_table || '" is     
    ''' || p_comment || '''';
END;

Upvotes: 1

Related Questions