Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: urgent help needed!! - connecting to db through unix script

Re: urgent help needed!! - connecting to db through unix script

From: <mpir_at_compuserve.com>
Date: 1998/03/16
Message-ID: <6ejb8l$26g$1@nnrp1.dejanews.com>#1/1

In article <Epwqv2.C8r_at_ccc.amdahl.com>,
  "WayneB" <Wayne_Leone_at_notes.amdahl.com> wrote:

Try sqlplus script to output values to a file, then a Korn Shell read loop setting up the export commands.

You may need to add a shell layer to the session. I have never been able to ripple the new environment variables back up the the calling shell. But I am not a Unix heavy--someone else can probably point you better at that one.

>
> Hi all,
>
> This is someting I need to solve as soon as possible.
>
> From unix shell script I need to
>
> 1. Connect to a database
> 2. Retrieve values from a table
> 3. For each value, assign to an environment variable.
> 4. Close connection
>
> When the scripts finishes, I need to be able to see the environment
> variables
> by doing 'set' or 'env' (doesn't matter which one just so long as I can see
> the values
> from the command prompt).
>
> Thanks in advance.
> Wayne Leone
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Mon Mar 16 1998 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US