Don't pass the double-quotes in the first place, they are completely unnecessary there unless you have something like <shudder> a mixed-case table name.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Did you try executing the same from any of the Oracle Client. If it is working then try the same in Datastage. Try to pass the value of the parameter as including double quotes.
But this is not the standard table naming convention.
Are you saying the double-quotes are actually part of the table name? That's hard to believe and a horrible practice if true.
Are you certain? Have you tried the query without them to see if it works that way? Many tools like Toad optionally quote object names like that, the vast majority of the time it isn't needed.
-craig
"You can never have too many knives" -- Logan Nine Fingers
Yes , double quote is a part of table name, table is like SCHEMA.AA_"SAMPLE". By describing table defination , I found that table name has quotes.
I tried to select query from a tool , if I am passing table name without quote, the query is not running(invalid table name) and with quote query is running properly
But in datastage same query is not working. I tried to pass without quote in DataStage . That is also not working.