Running a Windows batch file based on ROWCOUNT of a table

Running a Windows batch file based on ROWCOUNT of a table

 

  

Hi all,

If I want to run a windows batch file based on the rowcount <> 0 of a table
then how should I do that ?
IF I use a PL/SQL block to SELECT and TEST rowcount then I can not use HOST
command to call batch file.

On the other hand If I don't use PL/SQL then I can not test rowcount <>0 .

Pls. advise
Thanx

Oracle LazyDBA home page