SQL Queries - CAST Knowledge Base - Queries on objects - How to get the object types calling a specific object type

The purpose of this page is to provide a query which is run on the CAST Knowledge Base which provides all of the object types calling another specific object type. For example, if you want to see the object types (such as VB Function, Java Method) that are calling an Oracle table, then this query can be used for that purpose.

To get the list of all object types in the KB, run the following query:

SELECT   COUNT(*),
         object_type_str
FROM     cdt_objects
GROUP BY object_type_str;

This type can then be used in the following query to determine the other types which are calling this object type. For example, for VB function, use the following query (the value for callee.object_type_str can be modified for the object type desired to be examined):

Select distinct
caller.object_type_str CALLERS
from cdt_objects caller, cdt_objects callee, ctv_links caller_callee
where caller.object_id = caller_callee.caller_id
and callee.object_id = caller_callee.called_id
and callee.object_type_str = 'VB Function';