Hi,
We have a stored procedure that generates a report of the number of records inserted, updated, warnings, errors etc., This report is generated using a bunch of PRINTs. The stored procedure does not return any output parameter but we need to capture these PRINTs in our integration. I have looked at all the jdbc adapter services, they seem to give out an output if there is one returned from the stored procedure. But the PRINTs are not returned as output.
I tried using isql.exe utility of SQL to store them on a file. But I believe it is not a recommended way and also currently do not have sql client installed, please let me know if anyone knows of a way to capture these using webMethods.
Thanks,
Vitan