How and which component to use for taking SQL as input , process and load the result to a table

Anonymous — Thu, 21 Mar 2019 16:13:57 GMT

Hi All,

I have a client requirement to populate the output of SQL into table.

Already they have a ERP system and reports are accessible from ERP which use the SQL.

The ORACLE SQL used in the ERP system has many sub quires and db function and packages.

To achieve the requirement of taking this kind of SQL as a input and populate the output what is the process and component to be used.

Re: How and which component to use for taking SQL as input , process and load the result to a table

akumar2301 — Thu, 21 Mar 2019 16:25:16 GMT

ideally in tOracleRow , you can run any query which runs in Other Oracle client.

Just that Query should be coverted as Java String

e;g; SELECT LabelState FROM us_state

should be in double quoted before used in tOracleRow : "SELECT LabelState FROM us_state"