DDL.CREATE_WRAPPED
I have p/l sql block that wraps db objects by running the commands below:
SYS.DBMS_DDL.CREATE_WRAPPED(ddl => l_source,
lb => 1,
ub => l_source.count);
dbms_output.put_line('The ' || p_object_type || ' ' || p_object_name || ' has been wrapped and compiled');
however, it won't wrap some of the objects. the putline command says that it wrapped them, however the objects aren't wrapped. it generates no errors. it calls ddl_create_wrapped, no problem. are there restrictions on ddl_create_wrapped?
rae
SYS.DBMS_DDL.CREATE_WRAPPED(ddl => l_source,
lb => 1,
ub => l_source.count);
dbms_output.put_line('The ' || p_object_type || ' ' || p_object_name || ' has been wrapped and compiled');
however, it won't wrap some of the objects. the putline command says that it wrapped them, however the objects aren't wrapped. it generates no errors. it calls ddl_create_wrapped, no problem. are there restrictions on ddl_create_wrapped?
rae
0