Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Parameter Passing using Batch Files and SQLPlus
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.
Received on Fri Oct 01 1999 - 15:21:30 CDT