How to create a Visual Expert Project With Oracle PL/SQL Code

Step 1 – Add Oracle Code

  • Go to [file – New Project]
  • Select "Oracle PL/SQL"
    Select Oracle code to analyze with Visual Expert
  • Specify where your Oracle code is located
    Source of Oracle source code analysed with Visual Expert

Step 2 – Select the objects you wish to analyze

Important: if you’re connecting to a database, Visual Expert will analyze all the objects accessible from this connection, including all schemas, tables, procedures, system objects, etc. In this case, it is highly recommended to filter the DB objects you wish to analyze:
DB objects listed by default by Visual Expert

If you click on “More Filters” you get the following options:

Filter the DB objects you wish to analyze with Visual Expert

Once your Oracle object selection is completed, click “next” > select “Continue Setup”

Continue Visual Expert project Setup

  • Name your Visual Expert project
  • Set the scheduler to refresh your code analysis automatically on a regular basis
  • Select “Launch the analysis”
  • After analysis, you will Oracle and PL/SQL objects in the treeview

List of Oracle objects found by Visual Expert

  • You will also see 2 sources of code in your VE project.
    Go to [Code Analysis - Select Source Code].

PowerBuilder and Oracle source code location

Step 3 - Remove ambiguities and duplicate tables

Why this step?

Select  firstname,  lastname  from  employee 
Select firstname, lastname from myschema.employee

This basic example may create an ambiguity:
By default, the Visual Expert code parsers cannot know whether employee and myschema.employee refer to the same table. Unless we remove this ambiguity, Visual Expert will duplicate the table employee.

Please read this article to remove possible ambiguities in your project.