tOracleOutput – Talend Components V5.6.3.20160127_1448

tOracleOutput
Name: tOracleOutput
Icon: tOracleOutput
Description: Inserts or updates lines into an Oracle table
Author: Talend
Version: 5.6.3.20160127_1448
Download:

tOracleOutput V-5.6.3.20160127_1448 – Direct download

Example: Coming soon…
Install Instructions:
  • 1.Close your studio
  • 2.Extract the content of tOracleOutput.zip in a temporary folder
  • 3.Copy the content of tOracleOutput into your studio installation path to components folder: Talend-Studio -> plugins -> org.talend.designer.components.localprovider_5.6.3.20160127_1448 -> components
Release Date: 20070314A
Families:
  • Databases/Oracle
Connectors:
  • FLOW
  • FLOW
  • ITERATE
  • SUBJOB_OK
  • SUBJOB_ERROR
  • COMPONENT_OK
  • COMPONENT_ERROR
  • RUN_IF
Returns:
Name Type Description
NB_LINE id_Integer Number of line
NB_LINE_UPDATED id_Integer Number Of Updated Lines
NB_LINE_INSERTED id_Integer Number Of Inserted Lines
NB_LINE_DELETED id_Integer Number Of Deleted Lines
NB_LINE_REJECTED id_Integer Number Of Rejected Lines
QUERY id_String Query
Imports:
NAME MODULE REQUIRED_IF
Driver-Oracle-XDB xdb.jar SCHEMA.DB_TYPE IN [‘XMLTYPE’]
Driver-Oracle-XMLPARSERV2 xmlparserv2.jar SCHEMA.DB_TYPE IN [‘XMLTYPE’]
Talend-oracle-timestamptz talend-oracle-timestamptz.jar (DB_VERSION == ‘ORACLE_11-6′) OR (DB_VERSION==’ORACLE_11′) OR (DB_VERSION==’ORACLE_10’)
ORACLE_12 ojdbc7.jar (DB_VERSION == ‘ORACLE_12’) AND (USE_EXISTING_CONNECTION == ‘false’) AND (SPECIFY_DATASOURCE_ALIAS == ‘false’)
ORACLE_11-6 ojdbc6.jar (DB_VERSION == ‘ORACLE_11-6’) AND (USE_EXISTING_CONNECTION == ‘false’) AND (SPECIFY_DATASOURCE_ALIAS == ‘false’)
ORACLE_11 ojdbc6.jar (DB_VERSION == ‘ORACLE_11’) AND (USE_EXISTING_CONNECTION == ‘false’) AND (SPECIFY_DATASOURCE_ALIAS == ‘false’)
ORACLE_10 ojdbc14.jar (DB_VERSION == ‘ORACLE_10’) AND (USE_EXISTING_CONNECTION == ‘false’) AND (SPECIFY_DATASOURCE_ALIAS == ‘false’)
ORACLE_9 ojdbc14-9i.jar (DB_VERSION == ‘ORACLE_9’) AND (USE_EXISTING_CONNECTION == ‘false’) AND (SPECIFY_DATASOURCE_ALIAS == ‘false’)
ORACLE_8 ojdbc12.jar (DB_VERSION == ‘ORACLE_8’) AND (USE_EXISTING_CONNECTION == ‘false’) AND (SPECIFY_DATASOURCE_ALIAS == ‘false’)
Overview:

Component get from Talend
Thank you for watching.

Was this article helpful?
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x