Select RECID In Oracle Giving Wrong Data

Highlighted
Six Stars

Select RECID In Oracle Giving Wrong Data

Hi guys,
I'm attempting to extract data from an Oracle XML database using Talend. I was able to pick individual fields using 'extractvalue' keyword.
DESC FBNK_FCC_000
Name      Null     Type          
--------- -------- ------------- 
RECID     NOT NULL VARCHAR2(255) 
XMLRECORD          SYS.XMLTYPE   

The problem though is that the primary key field is called RECID and for some reason Talend returns some large number whenever I select RECID instead of the actual value in that field.
From google searches it seems I am picking the record identifier (a reserved keyword in Oracle) as opposed to my field name.
I have tried using TABLE_NAME.RECID to no avail.
Anyone with idea on how to get this working?
Moderator

Re: Select RECID In Oracle Giving Wrong Data

Hi,
Would you mind posting your component setting screenshot into forum?
Can you use your sql query in oracle client to extract data successfully without using talend tool? 
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Six Stars

Re: Select RECID In Oracle Giving Wrong Data

The issue seems to have been fixed since I installed full Oracle Client 11g.
Thanks though.
Just to answer the question, the script I was using was:

SELECT RECID AS ACCOUNT_NUMBER,
extractvalue(XMLRECORD,'/row/c26') as CLEARED_BALANCE,
extractvalue(XMLRECORD,'/row/c27') as WORKING_BALANCE
FROM FBNK_ACCOUNT

And the script was picking the correct values if using SQL Developer or DBeaver.
Moderator

Re: Select RECID In Oracle Giving Wrong Data

Hi,
Thanks for your prompt reply and sharing your solution with us.
Can we consider this topic as resolved?
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.