= Instructions =
# <ol><li>Configure the Oracle server in the TNS Names of your Oracle client:## * Locate the file ''tnsnames.ora'' in the directory '''[ORACLESOFTWARE]\network\admin\'''## * Configure the connection and call it (like in this example TESTDB):<br/>
<source lang="text">
TESTDB=
)
</source>
# </li><li>Use the [[Activity:CreateOLEOracleScope (Activity)]] activity to configure the connection via the arguments:</li>
#* the Oracle database '''DataSource'''
#* the '''InitialCatalog'''
#* '''UserName''' and '''Password'''
# <li>Use the [[Activity:CreateOLETableScope (Activity)]] activity or a [[Activity:CreateOLEQueryScope (Activity)]] to define the table you want to fetch data from. Set the tablename in the '''DisplayName''' argument.</li># <li>Use a '''ForEach<DataRow>''' activity to iterate over the records fetched from the table.</li># <li>A column of the recordset (table) can be accessed by its index.</li></ol>
=Example=