I'm starting SonicESB & DataServices evaluation.

The first scenario I want to test is to create an ESB service which calls Oracle stored procedure which returns recordset (e.g., cursor).

I haven't find proper information in product documentation.

Could anyone please help me?

Concrete questions are:

1. What are requirements for stored procedure, i.e. what is procedure/function signature?

2. How to define proper ESB Database Operation?

Thanks in advance!