Hi all,
Sorry if I bundle these different issues all together:

1. When should one use "WHERE CURRENT OF" clause? Is not it redundant cause I can implement it in where clause of my DML statement?

2. What is the benefit of pakcage level cursors? Will they boost the performance or just cause risk in multi-session applications such as a portal?

3. What is the benefit of a strong-type cursor type when I can use weak-type cursor types (such as oracle's built-in sys_refcursor)? It just increase the chance of type-mismatch, I mean when you are OPEN it FOR a cursor, does not it? Assumption: Host environment will be Java that call pl/sql procedures and take result sets from them.

-Your help and clarifications are really appreciated.