[resolved] Custom function call in tOracleInput

[Anonymous]

Hello,
I have created and compiled a function in oracle, and when i use it in sqldevelloper it works fine:
SELECT 
  SANSACCENTMANU(ad.NOM), 
  SANSACCENTMANU(ad.NOMMARITAL), 
FROM ORHUS6PROD.EXTRACTAD_ORHUS ad
LEFT JOIN ORHUS6PROD.PSITES s ON ad.CODESITE = s.SI_CODSITE

But when I use the same SELECT query in tOracleInput in have the error:
Exception in component tOracleInput_1
java.sql.SQLException: ORA-00904: SANSACCENTMANU: invalid identifier

I have test with \" ... \"  ,  with INSTACE.FUNCTION, with \"INSTANCE.PACKAGE.FUNCTION\" ....
I can't call custom function in tOracleInput, and I don't understand why.
Thanks for your help.

[Anonymous]

Hi,
Have you tried to use component TalendHelpCenter:tOracleSP to call your custom function? This component offers a convenient way to centralize multiple or complex queries in a database and call them easily.

Best regards
Sabrina

[Anonymous · Accepted solution]

Hi, 
I resolved the issue by call with \"SCHEMA.FUNCTION\"() and set EXEC rights on function for user connected by tOracleInput.
Regards,