SQL & PL/SQL

Hello all,

I want to discuss a scenario with u all.

I have a stored procedure 'A' which invokes two SPs 'B' and 'C'.

B in turn invokes two more SP D and E.

C invokes F and G.

D,E,F,G - perform some match on table/s based on some criteria input to them and return a REF CURSOR each.

B,C - invoke D,E,F,G respectively , receive REF CURSORs and pass them to A.

A - invoked by a Java module which receives 4 REF CURSORs.

Each REF CURSOR points to result set cintaining approx 10 columns and can have maximum 100 rows.

All I am concerned about is will such design cause any performance issues like high turnaround, too many cursor open , out of memory?

This is just a representitive of the scenario I have. There can be more than 4 REF CURSORs returned.

- Onkar