Calling same procedure in parallel

Shell Programming and Scripting
1

hi ,

I want to call same oracle procedure with different arguments in parallel.
how can i do this in shell script.

Pls help.

2

may be this helps : gnu dot org /software /parallel /man.html

install "parallel"

3 
nohup sqlplus ${username}/$(password}@${DB} exec proc1() &
nohup sqlplus ${username}/$(password}@${DB} exec proc2() &
4

I'm using <<EOF with sqlplus..
how to use nohup and & with it when im calling my oracle procedure.

5

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} <<EOF > output_2.log &
SET FEED OFF
EXECUTE proc2(param);
EXIT;
EOF