I am trying to send data from dabase to file system . If data is written successfully to a file system then i want to write success message to another database table if i is failure then i want to write error message to database table . I am not sure how to handle this.
The better option is use BPM for u r scenario
Hope this Web Log from Michael will help u
and also this one