posted 20 years ago
Hi Srikanth,
As far my little knowledge goes, if you are calling stored procedure from JDBC and SP needs to return multiple rows then you can choose to return either nested table or ref cursor. Ref cursor has advantage that Oracle9i free the memory space when you close the statement.Unlike nested table which oracle keep in memory until you close the connection. If you are using connection pool then it will be a problem .
Correct me if I wrong.
Sonu