Ask a Question

Query doesn't return records in JDBC Test Step, but works fine in Oracle SQl Editor

fgimenes
Occasional Contributor

Query doesn't return records in JDBC Test Step, but works fine in Oracle SQl Editor

Hi, I am trying to run this query in JDBC Test Step:

 

SELECT ACCOUNT.ID
        FROM PERSON JOIN CLIENT on PERSON.ID = client.person_id
            JOIN CLIENTACCOUNTMAP on client.id = CLIENTACCOUNTMAP.CLIENT_ID
            JOIN ACCOUNT on ACCOUNT.id = clientaccountmap.account_id
        WHERE mobilephone = '0468 600 391'

 

 

But t doesn't return any record. But when I run from Oracle directly, records are returned just fine:

fgimenes_0-1662645688859.png

Does anyone have any idea? Thanks

 

0 REPLIES 0
cancel
Showing results for 
Search instead for 
Did you mean: