Test DB Output

Oct 9, 2007 at 1:24 AM
How can I test DB output without actually do an query to the database or dump the output result to a file?
Scenario:
Input
- XML File via File Adapter
Output
- a request to a stored procedure to update a column in the table (Need success criteria defined here like POId = 123)
- a response from the stored procedure stating successfully updated the table (Need success criteria defined here like Status = Success)

In other words, can I test DB output success criteria using some kind of cache or interception when calling a stored procedure or SQL query?

I just need to confirm whether this possible or not. Please reply. Thanks.

Kenny