dev1>>cat sqlplus_proc.ksh
## create or replace procedure my_proc (p_rows in number) is
## begin
##    for i in (select object_id * rownum * rownum big_num, object_name, created
##                from user_objects where rownum <= p_rows) loop
##       dbms_output.put_line 
##           (lpad (i.big_num, 15, ' ')|| ' ' || rpad (i.object_name, 15, ' ')|| i.created);
##    end loop;
## end;
## /

user=xxx
pass=yyy
db=devdb

num_rows=5

sqlplus -s /nolog <<EOF > tmp.txt
  whenever sqlerror exit sql.sqlcode rollback
  connect $user/$pass@$db
  set feedback off
  --default date format (ideally not needed - should be controlled in proc)
  alter session set nls_date_format='dd-Mon-yyyy hh24:mi:ss';
  --preserve leading spaces and set dbms_output size
  --size maybe not needed in 10g server?
  set serveroutput on size 1000000 format wrapped 
    exec my_proc($num_rows);
  --exit sql.sqlcode;
EOF
rv=$?

echo "---- start output ----"
grep -v "Connected." tmp.txt
echo "---- end output ----"

echo Retval is $rv

# minute (0-59) = 00
# hour (0-23) = 16
# day of the month (1-31) = 8-14
# month of the year (1-12) = * (ALL)
# day of the week (0-6 with 0=Sunday) = 3
# Min Hr DayOfMon  Mon DayOfWk Script
# 00  16 8-14      *   3       . ~/cron_env; ~/sqlplus_proc.ksh >sqlplus_proc.cron.log 2>&1