Source Extractor - SQL PLSQL

*Purpose

This page provides the approach to troubleshoot the issues encountered while running SQL PLSQL extractors:

Source Extractor is a Component of CAST AIP that will help you Extract your Source code and help you analyze them using CAST.

Database Source extractors are meant for the version which they have been delivered. For example, if you are using CAST 8.3.5, then you should use the extractor that comes with 8.3.5. If you are using CAST 8.3.47, then you should use the extractor that comes with 8.3.47. If there is some extraordinary reason you are mixing versions of extractors and CAST versions and having problems, then please contact support with the reason for this and the error: CAST Technical Support.

For more information, refer to:

For 8.3 : CAST Database Extractor
Online Help: CAST Delivery Manager Tool- Help > Source Code Package page > Package Configuration tab > Where is your source code? > Oracle
TKB page for Information Guides : Information Guides > Information Guides by CAST AIP Component> Source Extractors

*Observed in CAST AIP

elease	Yes/No
8.3.x

*Observed on RDBMS

RDBMS	Yes/No
Oracle Server
CSS

Action Plan

The Oracle SQL Extractor uses JDBC Driver with Oracle Thin driver.

It requires no software other than JAVA and the driver jar file (it is embedded in the Extractor). This driver connects to Oracle databases via TCP/IP.

During the PL/SQL extraction, the source code extractor will run a set of queries that will export all the SQL objects requested for the PL/SQL analyzer.

Open the Source extractor log file:
1. If the Source extractor is a standalone extractor, it is generating its own log file. Open this log file using NotePad++
2. If the Source extractor is in DMT, open the extraction.CastLog2 using the CastLog2Viewer.exe that is in <CAST INSTALLATION FOLDER>/DeliveryManagerTool Folder
Identify in the source code extractor log file what is the step of the extraction :
The 2 first lines are the connection step.
From the third line, the one starting with Vendor: Oracle, it is the extraction step.
Navigate to the step where the issue occured
If you do not find the information you are looking for or solution for your problem, contact CAST Technical Support and provide the relevant input to help CAST Support team investigate your problem or procure the required information.

Notes/comments

Related Pages