CMS Snapshot Analysis - Run Analyzer - Missing or Wrong Links per technology - PL SQL - Missing link between source code of any technology and Oracle table

This page provides the solution to the issue of Missing link between any source code and Oracle database table.

Example code: 

test.php
--------------------------------
--------------------------------
require 'connection_db.php';

         $result = mysql_query("select * from table1 where AN_OP='".$_SESSION['Oper_Saisie']."' and AN_CODE='0000000041' and AN_AIF='O' ");
---------------------------------

So here link is expected from tect .php to table "table1"

This issue may occur if table table1 is stored in lower case in oracle

For example :

Create table "table1"(AN_OP varchar(30),AN_CODE varchar(30), AN_AIF varchar(30));

Here since table table1 is in “” it is created in lower case and hence no subset is created and no links are created.
So the solution is to

1. Create table in upper case

   Create table table1(AN_OP varchar(30),AN_CODE varchar(30), AN_AIF varchar(30));

   In above example script should be without “”  which will create table in upper case

2. Extract again

3. Run analysis again.