comment 是一个 DDL,要用execute immediate来执行,并且不能放在函数中create or replace procedure f_db_cm_comment(rest number(2))
is
begin
execute immediate 'comment on table USEUNITCODE is ''组织机构''';
execute immediate 'comment on column USEUNITCODE.USEUNITID is ''机构编号''';
EXCEPTION
WHEN OTHERS THEN
rest:=-1;--例外处理
end f_db_cm_comment;
is
begin
execute immediate 'comment on table USEUNITCODE is ''组织机构''';
execute immediate 'comment on column USEUNITCODE.USEUNITID is ''机构编号''';
EXCEPTION
WHEN OTHERS THEN
rest:=-1;--例外处理
end f_db_cm_comment;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货