ut_annotation_cache_manager.md

UT_ANNOTATION_CACHE_MANAGER

• UPDATE_CACHE Procedure
• GET_ANNOTATIONS_FOR_OBJECTS Function
• CLEANUP_CACHE Procedure
• PURGE_CACHE Procedure

UPDATE_CACHE Procedure

utPLSQL - Version 3
Copyright 2016 - 2017 utPLSQL Project

Licensed under the Apache License, Version 2.0 (the "License"):
you may not use this file except in compliance with the License.
You may obtain a copy of the License at

  http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software
distributed under the License is distributed on an "AS IS" BASIS,
WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
See the License for the specific language governing permissions and
limitations under the License.

Syntax

procedure update_cache(a_object ut_annotated_object)

GET_ANNOTATIONS_FOR_OBJECTS Function

Returns a ref_cursor containing ut_annotated_object as result
Range of data returned is limited by the input collection o cache object info

Syntax

function get_annotations_for_objects(a_cached_objects ut_annotation_objs_cache_info) return sys_refcursor

Parameters

Name	Description
a_cached_objects	a ut_annotation_objs_cache_info list with information about objects to get from cache

CLEANUP_CACHE Procedure

Removes cached information about annotations for objects on the list and updates parse_time in cache info table.

Syntax

procedure cleanup_cache(a_objects ut_annotation_objs_cache_info)

Parameters

Name	Description
a_objects	a ut_annotation_objs_cache_info list with information about objects to remove from cache

PURGE_CACHE Procedure

Removes cached information about annotations for objects of specified type and specified owner

Syntax

procedure purge_cache(a_object_owner varchar2, a_object_type varchar2)

Parameters

Name	Description
a_object_owner	owner of objects to purge annotations for
a_object_type	type of objects to purge annotations for