SQL query does not work in uipath, but does in Oracle SQL developer

Help Activities
, ,
1

Howdy all, I have this SQL below:

SELECT 
    substr(servprov_gid, instr(servprov_gid,'.')+1) as SCAC,
    attribute3 as Customer,
    substr(ivs1.shipment_gid, instr(ivs1.shipment_gid, '.') + 1) as ShipmentID, 
    invoice_number,
    invoice_date,
    attribute17 as ExceptionReason,
    attribute18 as ExceptionDesc
FROM invoice INV 
JOIN invoice_status ivs ON ivs.invoice_gid = inv.invoice_gid AND ivs.status_type_gid = 'RUAN.APPROVAL' 
WHERE LOWER(attribute17) LIKE Lower('%MISSING%')
and ivs.status_value_gid in ('RUAN.APPROVAL_FAILED','RUAN.APPROVAL_NOT_APPROVED')
ORDER by servprov_gid ASC, invoice_date DESC

This works perfectly in Oracle SQL developer. When I try and use it in UiPath though, I get the error

image

This makes zero sense to me as this works in oracle.

2

Try this:

SELECT
substr(inv.servprov_gid, instr(inv.servprov_gid,‘.’)+1) as SCAC,
inv.attribute3 as Customer,
substr(ivs.shipment_gid, instr(ivs.shipment_gid, ‘.’) + 1) as ShipmentID,
inv.invoice_number,
inv.invoice_date,
inv.attribute17 as ExceptionReason,
inv.attribute18 as ExceptionDesc
FROM invoice inv
JOIN invoice_status ivs ON ivs.invoice_gid = inv.invoice_gid AND ivs.status_type_gid = ‘RUAN.APPROVAL’
WHERE LOWER(inv.attribute17) LIKE LOWER(‘%MISSING%’)
AND ivs.status_value_gid IN (‘RUAN.APPROVAL_FAILED’, ‘RUAN.APPROVAL_NOT_APPROVED’)
ORDER BY inv.servprov_gid ASC, inv.invoice_date DESC;

3

I get a different error , “SQL command not properly ended”

4

Hi @David_Hernandez

Oracle SQL is case-sensitive inside double quotes. In your SQL environment, the identifiers might be recognized in a case-insensitive manner, but this may not be the case in other environments. Ensure that the case of the column names and aliases matches the actual case in the database schema.