How to create a Visual Expert Project With PowerBuilder + Oracle PL/SQL Code
Step 1 - Check the Requirements
Before you start:
- Download the latest build, and update your configuration.
- Verify that your key supports both PowerBuilder and ORACLE:
go to [Help - Info] - Check the "key features" in the right panel
If needed, read this article to request a new key
- Identify 1 set of PB code: 1 PB target OR 1 set of files/folders containing the PBLs
- Identify 1 set of PL/SQL code: 1 connection to an Oracle DB OR 1 set of files/folders containing both PL/SQL code and DDL statements (create table, etc.).
Step 2 - Add PowerBuilder code
- Go to [file – New Project]
- Select "PowerBuilder".
- Choose your PB version
- Specify the location of your PB code.
- Click "Next"
- Select "Add more code in your VE project".
Step 3 – Add Oracle Code
- Select "Oracle PL/SQL".
- Specify where your Oracle code is located
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:
If you click on "More Filters" you get the following options:
Once your Oracle object selection is completed, click "next" > select "Continue 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 see both PowerBuilder and Oracle objects in the treeview
- You will also see 2 sources of code in your VE project.
Go to [Code Analysis - Select Source Code].
Step 4 - 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.