ok, here's what i need to do. i have a unix shell script (hp unix, ksh shell) that is started each night via the crontab. i need the shell script to start, set shell variable, log into a database, check an oracle 8.1.7 table for a flag value. pass the value of this flag back to the unix shell script variable.
start shell script.
set unix variable.
log into oracle 8.1.7 (on same box).
check table for flag.
send flag value out to unix
if unix variable is x, do y
if unix variable is a, do b
so, is this possible? can you send the value of a pl/sql variable out to unix? please help.