Query doesn't return records in JDBC Test Step, but works fine in Oracle SQl Editor
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-08-2022
07:02 AM
09-08-2022
07:02 AM
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
Labels:
- Labels:
-
Function Tests
0 REPLIES 0
