Oracle Procedure to get path of MicroStrategy object using MicroStrategy Metadata

-- Create table
create table PROJECT_OBJECTS
(
  project_id  VARCHAR2(50),
  object_id   VARCHAR2(50),
  object_path VARCHAR2(1500)
);

create or replace procedure get_MSTR_Object_Path(p_project_id  varchar2)
as
begin
execute immediate 'truncate table PROJECT_OBJECTS';
INSERT INTO PROJECT_OBJECTS (Project_ID, Object_id, OBJECT_PATH)
WITH Parent1 (PROJECT_ID,OBJECT_ID, Parent_ID, object_type, OBJECT_PATH)AS
(
SELECT PROJECT_ID,
OBJECT_ID as OBJECT_ID,
Parent_ID as Parent_ID,
object_type as object_type,
cast(OBJECT_NAME as varchar2(4000)) as OBJECT_NAME
FROM
DSSMDOBJINFO
WHERE PARENT_ID in ( '98FE182C2A10427EACE0CD30B6768258','95C3B713318B43D490EE789BE27D298C')
and PROJECT_ID = p_project_id
UNION ALL
SELECT th.project_id,
TH.OBJECT_ID,
TH.PARENT_ID,
th.object_type,
cast( Parent1.OBJECT_PATH || '\' || TH.OBJECT_NAME as varchar2(4000)) AS Path
FROM
DSSMDOBJINFO TH
JOIN Parent1
ON Parent1.object_ID = TH.PARENT_ID and Parent1.project_id =th.project_id
where Parent1.object_ID = TH.PARENT_ID
and Parent1.project_id =Th.project_id
)

SELECT distinct Parent1.project_id as project_id,Parent1.object_id as object_id,'\Public Objects\'|| OBJECT_PATH as OBJECT_NAME FROM Parent1
where -- object_type  in (1,3,12,14,56) and
( Parent1.OBJECT_PATH NOT like  '%Regression%' and lower(Parent1.OBJECT_PATH) NOT like  '%unused%');
commit;
End;

Oracle DB gather schema statics

begin
DBMS_STATS.GATHER_SCHEMA_STATS ('xyz_931', OPTIONS=> 'GATHER AUTO');
DBMS_STATS.GATHER_SCHEMA_STATS ('xyz_931', OPTIONS=> 'GATHER AUTO');
end;