UNIX for Dummies Questions & Answers

Hi,

I am connecting to oracle DB from a unix script and below is how I am logging in with the parameters. this works fine, but the script connects to the DB thrice in different places and everytime these parameters have to be mentioned... which increases the lines in my script. In order to reduce the lines in the script, I would like to add these parameters to the environment file (which contains the path details in an environment) in a single variable.

Below is the code:

I added the parameters below to the environment file as ORA_DB_PARMS like below. but it didn't work.

Can some one help me how to add those parameters using a single variable in the environment file? I would like to add only one single variable called ORA_DB_PARMS which can contain all the parameters needed to connect to DB.

I am on Linux and my script is bash.

Thanks

You don't really need to export this. All you want is a shell variable.

If you don't put the text in quotes, it won't know it's all supposed to be in the variable and interpret them line by line.

Code:

ORA_DB_PARMS="
set feedback off
set heading off
set linesize 5000
set pagesize 0
set echo off
whenever sqlerror exit failure
whenever oserror exit failure"

Code:

. oracleparams

sqlplus -s <<sqlEOF
$ORACLE_USERNAME/$ORACLE_PASSWORD@$ORACLE_DB
$ORA_DB_PARMS
SELECT TO_CHAR(MAX(LAST_RUN_DATE) +1,'YYYYMMDD') FROM LOAD_HISTORY WHERE ENV_ID='ENVID' AND STATUS_OF_RUN ='SUCCESS';
sqlEOF