Re: Parameter Passing using Batch Files and SQLPlus

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_at_defiant.btitelecom.net>,   "Jeff Hunter" <jeffh_at_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_at_mydb @scriptname.sql arg1 arg2 arg3
>
> and arg1 will get substituted for &1, arg2 for &2 and so on...
>
> J
> narayana_ck_at_my-deja.com wrote in message
<7t30ke$clk$1_at_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 Fri Oct 01 1999 - 17:39:37 CDT