ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

using stored procedure vs ad hoc query

421641May 19 2004 — edited Jun 15 2004

Dears,

I am using Visual Studio 2003 with Oracle. It is said that we can performance benefits by using SPs. Definitly it will have some drawbacks as well. Some peoples says we should write everything in SP even simple select/insert. Others beleive using SP only when lengthy manipulation is reqd. So i want i know when one should use SPs.

Thanx in Advance,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 13 2004

Added on May 19 2004

#odp-net

6 comments

839 views