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