Re: Parameter passing from SQLPLUS to NT Batch

Thanks for reply

yes I did ask in comp.databases.oracle, but my isp has not updated it's feed to this since 3/4/02, which is why I then posted to this group

GC

"Bricklen Anderson" <bricklen_at_shaw.ca> wrote in message news:3CBB41F1.44C54C9_at_shaw.ca...
> 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:41:42 CDT