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

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 ""

fmid=$1

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

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

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

[Quoted] > 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
>
>