222: log(c_module, 'STATEMENT',
223: 'Getting DDLs for '||x_table_owner||'.'||x_table_name||', '||
224: x_object_type||', '||x_object_owner||'.'||x_object_name);
225:
226: l_open_handle := dbms_metadata.open(x_object_type);
227: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', x_object_owner);
228: dbms_metadata.set_filter(l_open_handle, 'NAME', x_object_name);
229: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
230: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
223: 'Getting DDLs for '||x_table_owner||'.'||x_table_name||', '||
224: x_object_type||', '||x_object_owner||'.'||x_object_name);
225:
226: l_open_handle := dbms_metadata.open(x_object_type);
227: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', x_object_owner);
228: dbms_metadata.set_filter(l_open_handle, 'NAME', x_object_name);
229: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
230: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
231: l_ddl_stmts := dbms_metadata.fetch_ddl(l_open_handle);
224: x_object_type||', '||x_object_owner||'.'||x_object_name);
225:
226: l_open_handle := dbms_metadata.open(x_object_type);
227: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', x_object_owner);
228: dbms_metadata.set_filter(l_open_handle, 'NAME', x_object_name);
229: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
230: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
231: l_ddl_stmts := dbms_metadata.fetch_ddl(l_open_handle);
232: dbms_metadata.close(l_open_handle);
225:
226: l_open_handle := dbms_metadata.open(x_object_type);
227: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', x_object_owner);
228: dbms_metadata.set_filter(l_open_handle, 'NAME', x_object_name);
229: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
230: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
231: l_ddl_stmts := dbms_metadata.fetch_ddl(l_open_handle);
232: dbms_metadata.close(l_open_handle);
233:
226: l_open_handle := dbms_metadata.open(x_object_type);
227: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', x_object_owner);
228: dbms_metadata.set_filter(l_open_handle, 'NAME', x_object_name);
229: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
230: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
231: l_ddl_stmts := dbms_metadata.fetch_ddl(l_open_handle);
232: dbms_metadata.close(l_open_handle);
233:
234: return l_ddl_stmts;
227: dbms_metadata.set_filter(l_open_handle, 'SCHEMA', x_object_owner);
228: dbms_metadata.set_filter(l_open_handle, 'NAME', x_object_name);
229: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
230: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
231: l_ddl_stmts := dbms_metadata.fetch_ddl(l_open_handle);
232: dbms_metadata.close(l_open_handle);
233:
234: return l_ddl_stmts;
235: end FETCH_MULTIPLE_DDLS;
228: dbms_metadata.set_filter(l_open_handle, 'NAME', x_object_name);
229: l_transform_handle := dbms_metadata.add_transform(l_open_handle, 'DDL');
230: dbms_metadata.set_transform_param(l_transform_handle, 'SQLTERMINATOR', false);
231: l_ddl_stmts := dbms_metadata.fetch_ddl(l_open_handle);
232: dbms_metadata.close(l_open_handle);
233:
234: return l_ddl_stmts;
235: end FETCH_MULTIPLE_DDLS;
236: