Re: Returning Oracle Variable to the Shell

From: Bill Marcum <bmarcum_at_iglou.com>
Date: Wed, 18 Apr 2001 00:22:02 -0500
Message-ID: <3add1655_3@news.iglou.com>

[Franklyn] wrote in message ...
>Problem: It does not populate the shell-variable $RUN_DATE from
>the database as I would expect. I want to get a value from the
>database and use it within my shell script. I'm missing something
>obvious here. (can this be done??).
>

A child process cannot change its parent's environment. Get Oracle to output the variable's value, and the shell can read it with a pipe or backticks. Received on Wed Apr 18 2001 - 00:22:02 CDT