Suggestions - DOS Command - Return value

I'm using Oracle 9i on Windows 2000 Professional:

I need to execute a command (DIR) and insert the number of files in the directory to a field. At some point, the file number will not grow, which I will have another field set to 'Done'. (Set to 'Done' by end user.)

I take it that once the file count is done, I will set a trigger on the 'Done' field, so the DOS command or whatever command I use does not execute in the future. And the highest file count will be inserted to database.

My questions are 'Do I use SQL to execute the DOS command?' And have it executed each time the user views the field? Unless it is set to 'Done' which in that case will give the highest file count. Or since I plan to use the web to add/view data to the database, use something like ASP to do all the work?

Hope you can follow my logic. Remember, that I'm new, not a student, just trying to learn Oracle 9i.

Thanks..

Ked Received on Mon Sep 30 2002 - 17:08:11 CDT