Re: Suggestions - DOS Command - Return value

"bigKED" <tme2slp_at_yahoo.com> wrote in message news:<fX3m9.49594$Fw2.1207285_at_twister.austin.rr.com>...
> 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

You can't execute a OS comand from SQL. SQL or PL/SQL is not an OS nor an 4GL.

I sugest you rethink your aricutecture for this problem. (PERL/java to log on to Oracle for instance) Received on Tue Oct 01 2002 - 08:09:33 CDT