I do not have answer to above question directly. as I am not using Oracle But i recommed you to prefer 1st approach as the code is more portable. I don't think there will be a lot of performance issue between the statements you mentioned.
But there are few ways you can improve performance 1. Use connection pooling, 2. If a statement is used more than once, prefer using Prepared statements. 3. Optimize your sql statements carefully before placing in your code. 4. Do not keep holding your connections, release them as soon as you are done. 5. Retrive the columns/Data you need from SQL, that will save network traffic 6. Cache the data that is used more often and does not change a lot These are few direct tips Hope they help Ratan...
Joined: Dec 27, 2002
subject: output parameter returned by the stored procedure