Re: Calling St. Procedure in UNIX script, How ?

From: Mike O <ora7dba_at_yahoo.com>
Date: Thu, 29 Nov 2001 21:09:43 -0600
Message-ID: <jQCN7.534$531.247352@news.uswest.net>

Jane... example of how to call another SQL job.. I think I have something for procedures somewhere too.. I will post if I find it.

#!/bin/ksh
#-----------------------------------------------------------------------
# Programmer:
# E-Mail:
# Date:
# FileName: sp_vru (Korn shell script, /bin/ksh)
#
# Description: This program runs sp_vru.sql for the Voice Recognition
# ~~~~~~~~~~~ Unit in <city>. It requires a parameter, FMID.
#
# Last Updated:
# ~~~~~~~~~~~~
#
# Comments:
# ~~~~~~~~
#-----------------------------------------------------------------------

if [[ -z $1 ]]; then

    echo ""
    echo "Usage : sp_vru <FMID>"
    echo ""

    exit
fi

fmid=$1

sqlplus -s <username>/<password>@dev @sp_vru $fmid

--------------<end>---------------------------------

"jane" <janeyiu_at_optonline.net> wrote in message news:sojN7.208$rS6.61809_at_news02.optonline.net...

> How does one call stored procedures in UNIX
> shell script (I'll take any flavor, thanks) and
> mostly, pass shell variables as parameters ?
>
> Thanks very much !
> jane yiu
>
>

Received on Thu Nov 29 2001 - 21:09:43 CST