Guess Schema not working in tOracleInput Component

[Anonymous]

Hi, 

I am getting error while clicking Guess Schema option in tOracleInput often.

After I write my query inside the Query box of the tOracleInput component, I clicked Guess Schema.

A pop up was displayed saying Connect to DB error, or some errors in SQL query string, or 'Guess Schema' not compatible with current SQL query string.

Then I have checked my DB connection (pointed inside the component), it was successful,

and I tried executing my SQL query string in Oracle developer, it was perfectly executed.

Is there any compatibility for Guess Schema option with respect to SQL query string?

Thanks in advance.

[Anonymous]

Hi,

    Could you please share your query and component detail screen shot for a quick look? If you are having any functions or column combinations without alias, it might create issue.

Warm Regards,

Nikhil Thampi