Re: Stored Procedures

[Phillip Ward]

If I assume that ...
- Invoice02 is a Table in your database, and
- Check01 a field within that table
... then I'm baffled as to why you'd want to use a Procedure for this at all.

If the intent is to delete all rows in Invoice02 that have the Check01 field set to 1, then this will do the job nicely:

delete 
from Invoice02
where Check01 = 1 ;

Of course, if you really do means "files" - sequences of bytes written to disk - then that's a whole other story!

Regards, Phill W.