One Star

tOracleInput questions

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
6 REPLIES
Community Manager

Re: tOracleInput questions

Hi
Try "select \"hello\" from dual"
Best regards
Shong
----------------------------------------------------------
Talend | Data Agility for Modern Business
One Star

Re: tOracleInput questions

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

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

Re: tOracleInput questions

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

Re: tOracleInput questions

hi
use "select 'hello' from dual"
One Star

Re: tOracleInput questions

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.