Search Results

trytable="v\$session"
var=`sqlplus -s ${DB_LOGON}<< EOSQL
WHENEVER SQLERROR EXIT FAILURE;
WHENEVER OSERROR EXIT FAILURE;
set longchunksize 200000 long 200000 pages 0
set heading off
select sid...

with single sqlplus tryfunction run_oracle {
var=`sqlplus -s <<%%
${DB_LOGON}
set serveroutput off
set heading off
set feedback off
set verify off
set define off
set linesize 2000
$1
exit...

again it is working for me
table structure changed to clobcreate table c (C clob);
mak.shvar=`sqlplus -s ${DB_LOGON}<< EOSQL
WHENEVER SQLERROR EXIT FAILURE;
WHENEVER OSERROR EXIT FAILURE;
set...

If nothing is printed of the statement, echo statement is being ignored...need to look into the other part of the code
by the way, what do you want to achive through the while loop?

r u sure?can you show your updated script?Its working my end.
#!/bin/bash
export fileclob
cd /home/appsuser/dataload
file='EG.mdd'
chmod 777 $file
dos2unix -ascii -k -q -o $file $file
sed -e...

How many directories you have? Are those fixed?

You can do something like..

for mydir in <dirs>
do
load_my_data $mydir &
done
wait



Inside load_my_data,

function load_my_data {...

How about this ?
#!/bin/bash

sqlplus -s apps/apps << EOF
whenever sqlerror exit sql.sqlcode;
set echo off
set heading off
delete from tablename;
exit;
EOF


for i in `ls`
do
nohup...

if you want to wait till that process is completed,
wait ${Process_ID}
You can capture multiple process id's is different variables and run the above command to wait for each

---------- Post...

add 'nohup' and '&'
nohup sqlplus -s ${USERNAME}/${PASSWORD}@${DBNAME} <<EOF > output_1.log &
SET FEED OFF
EXECUTE proc1(param);
EXIT;
EOF

nohup sqlplus -s ${USERNAME}/${PASSWORD}@${DBNAME}...

you can compare the paths of files, example:
if [ pathOfFile1 = pathOfFile2 ];then yourTreatment;fi