SYS.DBMS_FEATURE_JSON dependencies on DBMS_LOB

Line 66: dbms_lob.append(feature_info, to_clob ('"jsonColumns": {' ||

62: (select schema_name from v$sysaux_occupants)'
63: into num_varchar2_cols;
64:
65: /* Write Storage stats into clob */
66: dbms_lob.append(feature_info, to_clob ('"jsonColumns": {' ||
67: '"total":' || to_char(num_json_cols) || ' , ' ||
68: '"varchar2":' || to_char(num_varchar2_cols) || ' , ' ||
69: '"clob":' || to_char(num_clob_cols) || ' , ' ||
70: '"blob":' || to_char(num_blob_cols) || ' , ' ||

Line 105: dbms_lob.append(feature_info, to_clob ('"rowCount": {' ||

101: num_avg_rows := 0;
102: end if;
103:
104: /* Write row count stats into clob */
105: dbms_lob.append(feature_info, to_clob ('"rowCount": {' ||
106: '"maxCount":' || to_char(num_max_rows) || ' , ' ||
107: '"minCount":' || to_char(num_min_rows) || ' , ' ||
108: '"avgCount":' || to_char(num_avg_rows) || ' }, '));
109:

Line 137: dbms_lob.append(feature_info, to_clob ('"views": {' ||

133: not in (select schema_name from v$sysaux_occupants)'
134: into num_json_view;
135:
136: /* Write JSON view stats into clob */
137: dbms_lob.append(feature_info, to_clob ('"views": {' ||
138: '"total":' || to_char(num_json_view) || ' , ' ||
139: '"jsonValue":' || to_char(num_jv_view) || ' , ' ||
140: '"jsonExists":' || to_char(num_je_view) || ' , ' ||
141: '"jsonQuery":' || to_char(num_jq_view) || ' , ' ||

Line 164: dbms_lob.append(feature_info, to_clob ('"funcIdx": {' ||

160: END LOOP;
161: CLOSE expr_cur;
162:
163: /* Write JSON view stats into clob */
164: dbms_lob.append(feature_info, to_clob ('"funcIdx": {' ||
165: '"jsonValue":' || to_char(num_jv_fidx) || ' , ' ||
166: '"jsonExists":' || to_char(num_je_fidx) || ' , ' ||
167: '"jsonQuery":' || to_char(num_jq_fidx) || ' }, '));
168:

Line 192: dbms_lob.append(feature_info, to_clob ('"ctxIdx": {' ||

188: num_bson_cidx := 0;
189: end;
190:
191: /* Write JSON CTX index stats into clob */
192: dbms_lob.append(feature_info, to_clob ('"ctxIdx": {' ||
193: '"jsonCtxIdx":' || to_char(num_json_cidx) || ' , ' ||
194: '"bsonCtxIdx":' || to_char(num_bson_cidx) || ' } } '));
195:
196: /* set feature_boolean if reqd */