PRO*C,Cursor Limits,Reducing the cursor requirement:HELP

Hello!

        I am writing a multi-threaded program, which may contain upto 128 threads.

	each thread will do the following:


	+ open Table A and read one row at a time, till all rows are read


	and processed. The processing will be based on the data retrieved.


	+ If necessary, the thread will recursively read another table, 


	retrieve row by row and process it, and then finally return control
	to the table from which this was called.


	+ the thread will continue to process the other NOT-PROCESSED rows 


	in the original table.

	My program must handle the above table recursion.

System :
	Oracle 7.0.16

Questions :
1. Which is the best method of handling this? 2. How can I reduce the number of cursors used.? Can I have about 500 cursors in a single process?
3. Most of the threads may be (will be!) reading the same Tables and hence can I reduce the database FETCHes and improve the performance. 4. Has anyone faced similar situations?

Any help in this regard will be useful.

Thanks in advance
Vinaya_S1_at_blrv1.verifone.com