Select RECID In Oracle Giving Wrong Data

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.
Highlighted
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.

2019 GARNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

How Media Organizations Achieved Success with Data Integration

Learn how media organizations have achieved success with Data Integration

Read

APIs for Dummies

View this on-demand webinar about APIs....

Watch Now