[Home] [Help]
1: PACKAGE BODY ad_dbms_metadata AS
2: /* $Header: adgrants.sql 120.67.12020000.13 2013/05/15 11:19:38 mkumandu ship $ */
3: -- OPEN: Specifies the type of object whose metadata is to be retrieved.
4:
5: FUNCTION open (
7: version IN VARCHAR2 DEFAULT 'COMPATIBLE',
8: model IN VARCHAR2 DEFAULT 'ORACLE')
9: RETURN NUMBER IS
10: BEGIN
11: -- call the call dbms_metadata function
12: RETURN dbms_metadata.open(object_type, version, model);
13: END;
14:
15:
8: model IN VARCHAR2 DEFAULT 'ORACLE')
9: RETURN NUMBER IS
10: BEGIN
11: -- call the call dbms_metadata function
12: RETURN dbms_metadata.open(object_type, version, model);
13: END;
14:
15:
16:
29: name IN VARCHAR2,
30: value IN VARCHAR2) IS
31: BEGIN
32:
33: dbms_metadata.set_filter(handle,name,value);
34:
35: END;
36:
37:
51: handle IN NUMBER,
52: name IN VARCHAR2,
53: value IN BOOLEAN DEFAULT TRUE) IS
54: BEGIN
55: dbms_metadata.set_filter(handle,name,value);
56: END;
57:
58:
59:
69: PROCEDURE set_count (
70: handle IN NUMBER,
71: value IN NUMBER ) IS
72: BEGIN
73: dbms_metadata.set_count(handle,value);
74: END;
75:
76:
77:
85: FUNCTION get_query (
86: handle IN NUMBER)
87: RETURN VARCHAR2 IS
88: BEGIN
89: RETURN dbms_metadata.get_query(handle);
90: END;
91:
92:
93: ---------------------------------------------------------------------
101: PROCEDURE set_parse_item (
102: handle IN NUMBER,
103: name IN VARCHAR2) IS
104: BEGIN
105: dbms_metadata.set_parse_item(handle,name);
106: END;
107:
108:
109: ---------------------------------------------------------------------
122: name IN VARCHAR2,
123: encoding IN VARCHAR2 DEFAULT NULL)
124: RETURN NUMBER IS
125: BEGIN
126: return dbms_metadata.add_transform(handle,name,encoding);
127: END;
128:
129:
130: ---------------------------------------------------------------------
142: transform_handle IN NUMBER,
143: name IN VARCHAR2,
144: value IN VARCHAR2) IS
145: BEGIN
146: dbms_metadata.set_transform_param(transform_handle,name,value);
147: END;
148:
149:
150:
163: transform_handle IN NUMBER,
164: name IN VARCHAR2,
165: value IN BOOLEAN DEFAULT TRUE) IS
166: BEGIN
167: dbms_metadata.set_transform_param(transform_handle,name,value);
168: END;
169:
170:
171:
186: old_value IN VARCHAR2,
187: new_value IN VARCHAR2) IS
188: BEGIN
189: NULL;
190: -- dbms_metadata.set_remap_param(transform_handle,name,old_value,new_value);
191:
192: END;
193:
194:
205: FUNCTION fetch_xml (handle IN NUMBER)
206: RETURN sys.XMLType IS
207: BEGIN
208:
209: return dbms_metadata.fetch_xml(handle);
210: END;
211:
212:
213:
223: handle IN NUMBER)
224: RETURN sys.ku$_ddls IS
225: BEGIN
226:
227: return dbms_metadata.fetch_ddl(handle);
228: END;
229:
230:
231:
237:
238: FUNCTION fetch_clob (handle IN NUMBER)
239: RETURN CLOB IS
240: BEGIN
241: RETURN dbms_metadata.fetch_clob(handle);
242: END;
243:
244:
245: ---------------------------------------------------------------------
249: PROCEDURE fetch_clob (
250: handle IN NUMBER,
251: xmldoc IN OUT NOCOPY CLOB) IS
252: BEGIN
253: dbms_metadata.fetch_clob(handle,xmldoc);
254: END;
255:
256:
257: ---------------------------------------------------------------------
259: -- PARAMETERS: handle - Context handle from previous OPEN call.
260:
261: PROCEDURE CLOSE (handle IN NUMBER) IS
262: BEGIN
263: dbms_metadata.close(handle);
264: END;
265:
266: ---------------------------------------------------------------------
267: -- GET_XML: Return the metadata for a single object as XML.
285: model IN VARCHAR2 DEFAULT 'ORACLE',
286: transform IN VARCHAR2 DEFAULT NULL)
287: RETURN CLOB IS
288: BEGIN
289: RETURN dbms_metadata.get_xml(object_type,name,schema,version,model,transform);
290: END;
291:
292: ---------------------------------------------------------------------
293: -- GET_DDL: Return the metadata for a single object as DDL.
311: model IN VARCHAR2 DEFAULT 'ORACLE',
312: transform IN VARCHAR2 DEFAULT 'DDL')
313: RETURN CLOB IS
314: BEGIN
315: RETURN dbms_metadata.get_ddl(object_type,name,schema,version,model,transform);
316: END;
317:
318: ---------------------------------------------------------------------
319: -- GET_DEPENDENT_XML: Return the metadata for objects dependent on a
340: transform IN VARCHAR2 DEFAULT NULL,
341: object_count IN NUMBER DEFAULT 10000)
342: RETURN CLOB IS
343: BEGIN
344: RETURN dbms_metadata.get_dependent_xml( object_type,
345: base_object_name,base_object_schema,
346: version,model,transform,
347: object_count);
348: END;
372: transform IN VARCHAR2 DEFAULT 'DDL',
373: object_count IN NUMBER DEFAULT 10000)
374: RETURN CLOB IS
375: BEGIN
376: RETURN dbms_metadata.get_dependent_ddl(object_type,base_object_name,
377: base_object_schema, version,
378: model, transform, object_count);
379: END;
380:
378: model, transform, object_count);
379: END;
380:
381:
382: END AD_DBMS_METADATA;