DBA Data[Home] [Help]

SYS.DBMS_FEATURE_PRIV_CAPTURE dependencies on PRIV_CAPTURE$

Line 13: from sys.priv_capture$ where id# >= 5000;

9: WHEN 2 THEN 'ROLE'
10: WHEN 3 THEN 'CONTEXT'
11: WHEN 4 THEN 'ROLE_AND_CONTEXT'
12: END l_type
13: from sys.priv_capture$ where id# >= 5000;
14: l_capture priv_capture%ROWTYPE;
15: feature_usage varchar2(1000) := NULL;
16: l_prefix varchar2(100) := NULL;
17: l_count number := 0;

Line 25: select count(*) into l_count from sys.priv_capture$ where id# >= 5000;

21: feature_boolean := 0;
22: feature_info := NULL;
23:
24: -- total number of captures
25: select count(*) into l_count from sys.priv_capture$ where id# >= 5000;
26:
27: if (l_count > 0) then
28: -- feature is used if a capture is created
29: feature_boolean := 1;