#!/bin/ksh

sqlplus mylogin@mySID/mypassword<b><<</b>STR

variable name varchar2(30)
exec :name:=  'jai';

--method 1
execute my_test_proc(:name);

--method2
declare

v_name varchar2(30);

begin

for i in 1..5
LOOP
  v_name := to_char(i)||'XXXX';
  my_test_proc(v_name);
END LOOP;
end;
/

STR