topic Re: tOracleInput questions in Talend Studio

tOracleInput questions

_AnonymousUser — Sat, 16 Nov 2024 12:55:54 GMT

Hello,
I have a question about tOracleInput.
How can I get input strings properly?
For example I can write
"select 580 from dual"
this works fine, but when I try
"select "hello" from dual"
it gives me error no matter I use single or double quotes.
Thanks,
Henry

Re: tOracleInput questions

Anonymous — Tue, 10 May 2011 16:39:48 GMT

Hi
Try "select \"hello\" from dual"
Best regards
Shong

Re: tOracleInput questions

_AnonymousUser — Tue, 10 May 2011 16:48:29 GMT

Exception in component tOracleInput_1
java.sql.SQLException: ORA-00904: "hello": invalid identifier

This also does not work.. I guess in this way it treats hello as a field name.

Re: tOracleInput questions

Anonymous — Tue, 10 May 2011 16:54:56 GMT

is there a reason why you have it as "hello" and not hello?
Try "select hello from dual"
Regards
Brandon

Re: tOracleInput questions

_AnonymousUser — Tue, 10 May 2011 17:04:30 GMT

Exception in component tOracleInput_1
java.sql.SQLException: ORA-00904: "HELLO": invalid identifier
Again its the same error..

Re: tOracleInput questions

Anonymous — Tue, 10 May 2011 17:49:42 GMT

hi
use "select 'hello' from dual"

Re: tOracleInput questions

_AnonymousUser — Tue, 10 May 2011 18:04:12 GMT

hi
use "select 'hello' from dual"

That is correct. I believe I have tried that, not sure why it did not work...
Thanks a lot.