topic Re: Select RECID In Oracle Giving Wrong Data in Talend Studio

Select RECID In Oracle Giving Wrong Data

Anonymous — Thu, 04 Aug 2016 15:47:48 GMT

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?

Re: Select RECID In Oracle Giving Wrong Data

Anonymous — Mon, 08 Aug 2016 04:53:43 GMT

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

Re: Select RECID In Oracle Giving Wrong Data

Anonymous — Tue, 09 Aug 2016 12:21:21 GMT

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.

Re: Select RECID In Oracle Giving Wrong Data

Anonymous — Wed, 10 Aug 2016 09:12:41 GMT

Hi,
Thanks for your prompt reply and sharing your solution with us.
Can we consider this topic as resolved?
Best regards
Sabrina