I have a KSH script that I want to call in a loop for each row in the above table
---
new_script.ksh (psuedo code)
the contents on this new script would be something like below...
for t in (select table_name,schema_name from laod_table)
loop
/bin/load_table.ksh t.table_name t.schema_name
end loop
end
Can this be done in unix?
Please be more specific with your sql statement. Meaning are you running your code from the O/S to the Oracle server? Please show your code.
Oracle2066:cool:
Thanks for the quick response...basically what i am trying
to do is to create a new KSH script that will call a existing KSH script in a loop based on a
set of values from a SQL stmt...
..The KSH scripts will run in the AIX box..within the script i have to make a SQLPLUS connection to the database to run the select and then run the existing
KSH script in a loop...
Please cut & paste your code here. to see what it is doing. Moreover, What Ver is the Oracle DB are you running are you passing bind variables? calling stored procedures, functions or packages?
Oracle2066:cool:
---------- Post updated at 05:26 PM ---------- Previous update was at 03:59 PM ----------
Try this code below roadmap to success!!!!!!
#!/bin/ksh
if [ $# != 2 ]
then
echo �Please Only Call Or Contact When Oracle RAC Job Comes�
exit 1
fi
l_headhunters=$1
l_candidates=$2
l_candidates_n/a=$3
for i in 'seq $l_start_canidates_search
do
let l_next_candidates=$i+1;
l_candidate_log_file="/xxx/xxx/xxx/canlog_${2}_${i}_$l_next_candidate}.log"
-- connect to Oracle 11g r2
PROMPT "Connecting to Reventon RAC Clusters"
--
Sqlplus �s / as sysdba << EOC -- connect to database
set head off
set pages 0
set lines 132
set echo off
set feedback off
spool /xxx/xxxxxxx/Oracle_RAC_DBA_Candidates.log
Select name, address, city
from Hr.locations
where city = �New York, NY�
(�select name, Job_id from hr.employees
Join hr.departments
where hr.employees hr.departments = �Oracle RAC DBA�);
spool off
EOC
done
Oracle2066:b:
Oracle2066