Re: Parameter passing from SQLPLUS to NT Batch

why not have dbms_job run that query every hour, then pass that value out to a variable (or into a file etc, to be parsed by another script for the relevant value)?

you could also try posting to alt.msdos.batch or alt.msdos.batch.nt if you are so keen to have it all done by batch scripts. Didn't you ask this same question a couple/few days ago?

TC3 Racer wrote:
>
> I want to use an NT batch file, running every hour, to do a
>
> Select count(*) from tablename.
>
> I then want to pass the result out and if its zero, have another batch file
> that does various things
>
> How do I get the the value out of the sql script
>
> Thanks in advance
>
> GC
Received on Mon Apr 15 2002 - 16:14:46 CDT