tOracleInput questions

[_AnonymousUser]

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

[Anonymous]

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

[_AnonymousUser]

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.

[Anonymous]

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

[_AnonymousUser]

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

[Anonymous]

hi
use "select 'hello' from dual"

[_AnonymousUser]

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.