procedureShow(pVariablevarchar2,pLineSizepls_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);
endif;
endShow;
begin
--猎取DDL
vClob:=dbms_metadata.get_ddl(’TABLE’,upper(vTable));