XDB.XIMETADATA_PKG dependencies on DBMS_LOB

Line 35: pos := dbms_lob.instr(data, 'insert into', offset, 2);

31: END IF;
32:
33: -- we have long metadata
34: -- find the second occurence of 'insert into XDB.XDB'
35: pos := dbms_lob.instr(data, 'insert into', offset, 2);
36:
37: IF (pos = 0) THEN -- not found
38: current_plsql := DBMS_LOB.SUBSTR(data, 30000, offset); -- the rest
39: done := 1;

Line 38: current_plsql := DBMS_LOB.SUBSTR(data, 30000, offset); -- the rest

34: -- find the second occurence of 'insert into XDB.XDB'
35: pos := dbms_lob.instr(data, 'insert into', offset, 2);
36:
37: IF (pos = 0) THEN -- not found
38: current_plsql := DBMS_LOB.SUBSTR(data, 30000, offset); -- the rest
39: done := 1;
40: ELSE
41: current_plsql:= DBMS_LOB.SUBSTR(data, pos - offset -1, offset);
42: offset := pos;

Line 41: current_plsql:= DBMS_LOB.SUBSTR(data, pos - offset -1, offset);

37: IF (pos = 0) THEN -- not found
38: current_plsql := DBMS_LOB.SUBSTR(data, 30000, offset); -- the rest
39: done := 1;
40: ELSE
41: current_plsql:= DBMS_LOB.SUBSTR(data, pos - offset -1, offset);
42: offset := pos;
43: END IF;
44:
45: iterate := iterate + 1;