Re: How do you pass a value from a shell script into a sqlplus script?

From: Alan Mills <Alan.Mills_at_nospamservices.fujitsu.com>
Date: Mon, 21 Oct 2002 16:49:41 +0100
Message-ID: <ap17mm$1i64$1@news.icl.se>

It's been quite a while (about 5 years) since I've done this but if memory serves you simply reference command line parameters as &1, &2 ... from within SQL*Plus.

"Mike J" <mjjwestford_at_hotmail.com> wrote in message news:ur885v82jtbt45_at_corp.supernews.com...
> I gather parameter values in a korn shell script and want to use them in a
> sqlplus script that is called from the shell script. How do you pass a
value
> into the sqlplus script?
>
>
Received on Mon Oct 21 2002 - 10:49:41 CDT

This message: [ Message body ]
Next message: Cynic: "slightly OT: calling Oracle SP from VB"
Previous message: isa: "Re: How do you pass a value from a shell script into a sqlplus script?"
In reply to: Mike J: "How do you pass a value from a shell script into a sqlplus script?"
Next in thread: isa: "Re: How do you pass a value from a shell script into a sqlplus script?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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