44: and name not in ('METADATA', 'TEMPLATE')
45: and ctx_type = 'A'
46: and rownum=1;
47:
48: start_pos := DBMS_LOB.instr(lobd, '<' || tag_name, 1,1);
49: end_pos := DBMS_LOB.instr(lobd, '
50:
51: ret_string := dbms_lob.substr(lobd, end_pos - start_pos, start_pos);
52:
45: and ctx_type = 'A'
46: and rownum=1;
47:
48: start_pos := DBMS_LOB.instr(lobd, '<' || tag_name, 1,1);
49: end_pos := DBMS_LOB.instr(lobd, '
50:
51: ret_string := dbms_lob.substr(lobd, end_pos - start_pos, start_pos);
52:
53: ret_string := substr(ret_string,instr(ret_string,'>',1,1)+1);
47:
48: start_pos := DBMS_LOB.instr(lobd, '<' || tag_name, 1,1);
49: end_pos := DBMS_LOB.instr(lobd, '
50:
51: ret_string := dbms_lob.substr(lobd, end_pos - start_pos, start_pos);
52:
53: ret_string := substr(ret_string,instr(ret_string,'>',1,1)+1);
54:
55: return ret_string;