I've got an older system that can call a stored proc, but can't call a web service. The business logic from this stored proc is being migrated into a web service. Are there any ESB adapters that can simulate a database and accept input in the form of stored proc input variables, then turn around and call a web service? After the web service returns a result, the answer would need to be mapped into a result set and/or output variables and sent back to the client. I would prefer to use Spring Integration or Mule or some other Java-based ESB, but would be willing to consider other options.
If the legacy application uses JDBC, use the p6spy driver to intercept the calls and redirect them to the web service.