topic Re: [resolved] Custom function call in tOracleInput in Talend Studio

[resolved] Custom function call in tOracleInput

Anonymous — Mon, 17 Aug 2015 15:58:45 GMT

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.

Re: [resolved] Custom function call in tOracleInput

Anonymous — Tue, 18 Aug 2015 09:43:44 GMT

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

Re: [resolved] Custom function call in tOracleInput

Anonymous — Tue, 18 Aug 2015 12:13:59 GMT

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