SQL Queries - CAST Knowledge Base - Queries on objects - How to get the list of J2EE objects linked to Oracle PL SQL objects

Purpose of Query

This page provides a query to be run on Knowledge Base to get the list of J2EE objects linked to Oracle PL SQL objects

Applicable CAST Version

Release	Yes/No
8.3.x
8.2.x

Applicable RDBMS

RDBMS	Yes/No
Oracle Server
Microsoft SQL Server
CSS

Query for CSS

select 
co1.Object_Type_Str Java_Object_Type, 
co1.Object_Name Java_Object_Caller,  
co1.Object_Fullname Java_Object_FullName,  
co2.Object_Type_Str Oracle_Object_Type, 
co2.Object_Name Oracle_Object_Caller,  
co2.Object_Fullname Oracle_Object_FullName, 
clt.staticdesc Type_Of_Link
from ctv_links ctl
join CDT_OBJECTS co1 on co1.object_id = caller_id and lower(co1.object_type_str) like '%java%'
join CDT_OBJECTS co2 on co2.object_id = called_id and lower(co2.object_type_str) like '%oracle%'
join csv_linktype clt on link_type_lo = acctyplo and link_type_hi = acctyphi

Query result example

Query result interpretation

From the above query result , this query gets the list of J2EE objects linked to Oracle PL SQL objects

Query for Oracle

Same as CSS

Query result example

Query result interpretation

Query for SQL server

Same as CSS

Query result example

Query result interpretation

Notes/comments

Related Pages