Up: Using the interface:
Guidelines for application developers
- Try to group your database predicates and use the view level interface
to generate efficient SQL queries.
- Avoid cuts over cursors since they leave cursors open and can cause
a leak of cursors.
- Whenever you send a query get all the results sent by the Oracle by
backtracking to avoid cursor leaks. This interface automatically closes a
cursor only after you retrieve the last row from the active set.
- Try to use tabled database predicates for cashing database tables.