DBA Data[Home] [Help]

SYS.DBMS_OBJECTS_APPS_UTILS dependencies on SOURCE$

Line 222: -- argument sources and will split the source$ entry for the latest version

218: end; /* end of procedure update types */
219:
220: -- Function SPLIT_SOURCE
221: -- This function will take 3 arguments, schema name, type name and an OUT
222: -- argument sources and will split the source$ entry for the latest version
223: -- of the type to its CREATE and ALTERs and will return it in sources, with
224: -- with the corresponding obj#. The number or split sources will be the return
225: -- value of the functions.
226: -- The obj# here can be used to determine the order of execution of connected

Line 259: select line, source, length(source) from source$ where obj#= obj_id;

255: (select user# from user$ where name=tschema)
256: and type#=13 and subname is null;
257:
258: cursor c2 is
259: select line, source, length(source) from source$ where obj#= obj_id;
260:
261: cursor c3 is
262: select obj# from obj$ o, type$ t where t.version#=i and o.name=tname and
263: o.oid$=t.tvoid and o.type#=13;

Line 277: select count(*) into total_lines from source$ where obj# = obj_id;

273: total_len := 0;
274: source := '';
275: new_source := '';
276: -- First get the total no: of lines
277: select count(*) into total_lines from source$ where obj# = obj_id;
278: OPEN C2;
279: LOOP
280: FETCH C2 INTO line_no, tmpsource_line, line_len;
281: EXIT WHEN c2%notfound;