PROCEDURE: SYS.DBMS_FEATURE_UTILITIES3

Source

1 PROCEDURE dbms_feature_utilities3
2      ( feature_boolean  OUT  NUMBER,
3        aux_count        OUT  NUMBER,
4        feature_info     OUT  CLOB)
5 AS
6    feature_usage      VARCHAR2(1000) := NULL;
7    feature_count      NUMBER := 0;
8 BEGIN
9   -- initialize
10   feature_info      := NULL;
11 
12   begin
13     select usecnt into feature_count from sys.ku_utluse
14       where utlname = 'Oracle Utility Metadata API'
15        and   (last_used >=
16              (SELECT nvl(max(last_sample_date), sysdate-7)
17                FROM dba_feature_usage_statistics));
18   exception
19     when others then
20       null;
21   end;
22 
23   feature_boolean := feature_count;
24   aux_count       := feature_count;
25 END dbms_feature_utilities3;