Replace function error in T oracle component

[Divya3]

Hi,

I'm trying to run the select query with replace,substr function in T Oracle component. The job is throwing error. can you help?

"SELECT substr(ATLD_ID,1,8) as XXX

from YYYY"

[Anonymous]

Hello,

Could you please give us more information about the error message you're getting? In this way, we could address your issue in a quick way.

Best regards

Sabrina

[Divya3]

Hi,

I was actually trying to use this expression in Talend,

replace(REGEXP_SUBSTR(ATLT.atlt_to_name,'[^,]+',1,1),'"','') as Member_Firstname

The function works well in Oracle query but not in Talend. Can you please help?