DataServices:how to get Oracle stored proc output cursor?

Posted by Admin on 14-Nov-2007 03:02

Hi!

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!

All Replies

This thread is closed