Need efficient cursor management for large database.

From: Daniel Jach <danielj_at_frontiersoftware.com.au>
Date: Tue, 21 Nov 2000 15:25:08 +1100
Message-ID: <XMmS5.38038$SF5.711564@ozemail.com.au>

We have a PRO*C program which must access and update information in 200 different tables.

The transactions are generic in nature - each transaction accesses around 10 to 30 tables some read only and some for update.

We want to take advantage of prepared statements, etc.

How can we program this to avoid needing 200 declared cursors and 200 x 10 prepared statement?

Any ideas appreciated.

Thanks

Daniel Received on Mon Nov 20 2000 - 22:25:08 CST