ETL Scheduling Development (5)--Connect Database Execute database command subroutine

ETL scheduling Read and write data information, all need to connect to the database, the following sub-program through the incoming database connection string and Database command (or SQL) to perform the required actions:

#!/usr/bin/bash#created by Lubinsu#2014source ~/.bash_profilevalues= ' sqlplus-s << EOF  set heading off Feedback off pagesize 0 Verify off echo off    whenever SQLERROR exit SQL. SQLCODE ROLLBACK    commit;    Exit EOF ' echo ' ${values} "

Parameters are: Database connection string, Database command (or SQL statement)