VI Not Reading Oracle DB

No Global Variables. This is just a simple select
SELECT t.TransactionID AS AutoID,
       t.vessel_code AS SiteID,
       t.Update_user AS Create_User,
       t.Componentid,
       t.Spareid,
       t.Locationfromid,
       t.SparelocationID AS LocationToID,
       t.Transaction_Qty AS Transaction_Qty,
       t.Last_Update AS Transaction_Date,
       t.Notes,
       '0' AS RecordUpdated,
       t.Last_Update AS Update_Date,
       t.vessel_code AS Update_Site,
       'DANINT' AS Update_User,
       NULL AS ParentID,
       '0' AS LastImport
  FROM danint.Kapa_System_Subsystems t
 WHERE t.Interface_Flag = 'N'
   AND t.Deliverd_Status =1
   AND (t.Transaction_Qty IS NOT NULL
    OR t.Transaction_Qty <> 0)   

 

Please do the same but run

SELECT t.TransactionID AS AutoID,
       t.vessel_code AS SiteID,
       t.Update_user AS Create_User,
       t.Componentid,
       t.Spareid,
       t.Locationfromid,
       t.SparelocationID AS LocationToID,
       t.Transaction_Qty AS Transaction_Qty,
       t.Last_Update AS Transaction_Date,
       t.Notes,
       '0' AS RecordUpdated,
       t.Last_Update AS Update_Date,
       t.vessel_code AS Update_Site,
       'DANINT' AS Update_User,
       NULL AS ParentID,
       '0' AS LastImport
  FROM danint.Kapa_System_Subsystems t
 WHERE t.Interface_Flag = 'N'
   AND t.Deliverd_Status =1
   AND (t.Transaction_Qty IS NOT NULL
    OR t.Transaction_Qty <> 0) 

No change. You can see your suggested format in the foreground, and the background after I ran. St  ill no result.

Still no result

We can connect remotely and assist if you wish