Re: Parameter Passing using Batch Files and SQLPlus

From: John Chiu <johnymc_at_netscape.net>
Date: Sun, 03 Oct 1999 05:04:20 -0400
Message-ID: <37F71C14.272493FD@netscape.net>

Is it much easier to obtain system parameters from a database table in your application/other scripts.

John Chiu
johnc@relsol.com
 

narayana_ck@my-deja.com wrote:

You got me wrong. I need to have a sql script return a value back to
the batch file so that in turn it can pass that value to other sql
scripts and applications

In article <37f51810@defiant.btitelecom.net>,
  "Jeff Hunter" <jeffh@btitelecom.net> wrote:
>
> Yes, name your parameters &1, &2, &3, etc and then pass the variables
on the
> command line in that postion.  For example:
> sqlplus system/manager@mydb @scriptname.sql arg1 arg2 arg3
>
> and arg1 will get substituted for &1, arg2 for &2 and so on...
>
> J
> narayana_ck@my-deja.com wrote in message
<7t30ke$clk$1@nnrp1.deja.com>...
> >Platform: NT
> >Database: Oracle7.3.4 and above
> >
> >Is there a way i could have a sql script get a value from the
database
> >and set an environment variable to that value, so that my batch file
> >can utilize it to pass it as an parameter or argument to other
> >applications and sql scripts.
> >
> >thanks
> >ck
> >
> >
> >
> >
> >Sent via Deja.com http://www.deja.com/
> >Before you buy.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy.

  Received on Sun Oct 03 1999 - 04:04:20 CDT