1 / 3

Unnecessary parenthesis is added to tELTOracleOutput’s generated SQL 1

Unnecessary parenthesis is added to tELTOracleOutput’s generated SQL 1. This is screen for subquery check. It’s same SQL as tELTOracleMap generated. This is subquery for insert. This query is correct for Oracle command line. Result is returned.

kamuzu
Download Presentation

Unnecessary parenthesis is added to tELTOracleOutput’s generated SQL 1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Unnecessary parenthesis is addedto tELTOracleOutput’sgeneratedSQL 1 This is screen for subquery check. It’s same SQL as tELTOracleMap generated. Thisissubquery for insert. This query is correct for Oracle command line. Result is returned.

  2. Unnecessary parenthesis is addedto tELTOracleOutput’sgeneratedSQL 2 Run same SQL on Oracle command line, The same error occurred. It’s Generated SQL for ELT Job. It’s SQLException “ORA-00907 missing right parenthesis”

  3. Unnecessary parenthesis is addedto tELTOracleOutput’sgeneratedSQL 3 This SQL query is same as Talend generated one. It occurred error”ORA-00907”. This SQL query is removed subquery’s parenthesis from Talend generated one. It succsess.

More Related