File tree Expand file tree Collapse file tree 1 file changed +0
-18
lines changed Expand file tree Collapse file tree 1 file changed +0
-18
lines changed Original file line number Diff line number Diff line change @@ -139,24 +139,6 @@ create or replace package body ut_annotation_manager as
139
139
where x.is_annotated = 'Y'
140
140
order by x.name, x.line]'
141
141
using a_objects_to_refresh;
142
- raise_application_error(-20001, q'[select /*+ no_parallel */ x.name, x.text
143
- from (select /*+ cardinality( r ]'||l_card||q'[ )*/
144
- s.name, s.text, s.line,
145
- max(case when s.text like '%--%\%%' escape '\'
146
- and regexp_like(s.text,'^\s*--\s*]'||l_allowed_annotations||q'[%')
147
- then 'Y' else 'N' end
148
- )
149
- over(partition by s.name) is_annotated
150
- from table(:a_objects_to_refresh) r
151
- join ]'||l_sources_view||q'[ s
152
- on s.name = r.object_name
153
- and s.owner = r.object_owner
154
- and s.type = r.object_type
155
- where s.owner = ']'||ut_utils.qualified_sql_name(a_object_owner)||q'['
156
- and s.type = ']'||ut_utils.qualified_sql_name(a_object_type)||q'['
157
- ) x
158
- where x.is_annotated = 'Y'
159
- order by x.name, x.line]');
160
142
return l_result;
161
143
end;
162
144
You can’t perform that action at this time.
0 commit comments