procedure show (pvariable varchar2, plinesize pls_integer := 80) is begin dbms_output.enable(1000000); if (length(pvariable) > plinesize) then dbms_output.put_line(substr(pvariable, 1, plinesize)); show(substr(pvariable, plinesize + 1), plinesize); else dbms_output.put_line(pvariable); end if; end show; begin -- 获取 ddl vclob := dbms_metadata.get_ddl(’table’, upper(vtable));