Forum Discussion

fgimenes's avatar
fgimenes
Occasional Contributor
3 years ago

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:

Does anyone have any idea? Thanks

 

Function Tests
No RepliesBe the first to reply