CREATE OR REPLACE PROCEDURE My_Procedure
(i_name        IN VARCHAR2,
 i_address     IN VARCHAR2,
 i_id          IN NUMBER,
 o_new_id      OUT NUMBER,
 o_new_address OUT VARCHAR2,
 o_new_name    OUT VARCHAR2,
 error_number  OUT NUMBER,
 error_msg     OUT VARCHAR2) IS
begin 
 ....
 
end; 

#!/bin/sh
# set environment
. /set_env

i_name=$1
i_address=$2
i_id=$3

retval=`sqlplus  $CONN_DETAILS <<eof
set serveroutput on
whenever sqlerror exit -1
var o_new_id number
var o_new_address varchar2(500)
var o_new_name varchar2(500)
var error_number number
var error_msg varchar2(500)
exec My_Procedure('$1','$2',$3,:o_new_id,:o_new_address,:o_new_name,:error_number,:error_msg);
eof`
echo $retval > stat_file